Workbook.Open doesn't leave an open Workbook
My Code:
TS = Directory & File_Name
On Error Resume Next
Workbooks.Open TS
If Err Then
Call MsgBox("Could not open " & TS & ", " & Err)
End If
After this runs, there is no Error Message, but there is no Workbook open
either.
This code works if I put in Workbook_Open, but not if I use it in a normal
Function call.
Any idea why it works in one place and not in another?
Thanks,
Mac
|