Home |
Search |
Today's Posts |
#9
![]() |
|||
|
|||
![]()
Hi Veljo,
I used Bob's suggestion, 1. On Errror Resume Next Set nextFile = Workbooks.Open("filename") On error Goto 0 This portion will get rid of the irritation "run-time error". 2. If Not nextFile Is Nothing Then ...... begin your code Else End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |