Thread: Open a Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
papamobil68 papamobil68 is offline
external usenet poster
 
Posts: 1
Default Open a Workbook

Hi

I use excel in automation from a 3rd pary application.
This works ok, but is not robust enough if something is wrong with the file.
....
xlWorkBook := xlApp.Workbooks.Open(_FilenameAndPath)
...
Since in my 3rd party application I cannot use VBA, there nothing like 'On
Error goto...' Of course, I can check the existence of the file, but format
can still be wrong.


Any ideas to make this code more reliable?
Thank you in advance.
P