Thread: Open a Workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Markus Scheible[_2_] Markus Scheible[_2_] is offline
external usenet poster
 
Posts: 95
Default Open a Workbook

Hi unknown,

xlWorkBook := xlApp.Workbooks.Open(_FilenameAndPath)


Well, you could at least use a

If IsError(Workbooks.Open(FileName:="abcd.xls")) = True
Then

Else
End If

to catch the error of not having the file...


the file, but format
can still be wrong.


How do you mean that?

Best

Markus