View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Lingo[_2_] Mac Lingo[_2_] is offline
external usenet poster
 
Posts: 53
Default 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