Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation | Excel Programming |