Error handling on Workbooks.Open

Posted to microsoft.public.excel.programming

tom

external usenet poster

Posts: 570

Error handling on Workbooks.Open

Workbooks.Open ("H:\Checklist 07-23-07.xls")
Workbooks("CheckList.xls").Activate

What would be the best way to handle the error if the file does not exist?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error Handling - Check a file isn't already open before overwritin	NDBC	Excel Discussion (Misc queries)	4	August 13th 09 08:36 AM
Problem with handling on error when file is already open	Frank	Excel Programming	3	September 22nd 06 04:26 PM
workbooks.open and error handling	John Keith[_2_]	Excel Programming	5	August 18th 05 05:16 PM
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed	Frank Jones	Excel Programming	2	June 15th 04 03:21 AM
Error Handling Open Function or query for missing Files	BigNate	Excel Programming	3	June 11th 04 05:22 PM

All times are GMT +1. The time now is 07:16 AM.

Menu

About Us