Search results

  1. N

    VBA minimising Forms

    Morning, I currently have Excel 2007 at home but run 2003 at work the below code works brilliant to enable a form to minimise onto the windows toolbar and back again with 2007. However when I take it to work on 2003 it does work, basically when you minimise the form it does not appear on the...
  2. N

    Is Value in closed workbook

    I have been searching for a while but I can't find exactly what i'm looking for. Basically I have workbook which consists of valid post codes for the area (lets call it Postcode.xls). It is a large file and I am reluctant to open it due to network speed. I have a form run through another...
  3. N

    Filter Problem

    :banghead:Morning, I'm trying to find a way to filter a worksheet with one value on two different columns, but failing! The below code works a treat to filter one column on the correct value Worksheets("Update").Range("R1").AutoFilter _ field:=18, _...
  4. N

    Workbooks("test.xls").close stops program

    Need some help with an application i'm writing. The problem that i have is that i have a to open different workbooks which isn't a problem however no matter what happens when i use the close function it stops by program from running. I've use ActiveWorkbook.Close, Workbooks(2).Close and...
Back
Top Bottom