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
|