![]() |
|
#3
|
|||
|
|||
|
Hi Peter,
I would suggest adding False as the first argument to the Close method: XLWkb.Close False If you don't do this, Excel may, as Dave mentioned, be waiting for you to answer "do you want to save changes". Were these workbooks created with Excel 2000? If so, that would explain what you're seeing. Excel 2000 workbooks will always prompt you to save upon close when they are opened in Excel 2003. But regardless of what's causing the problem, adding False is a good practice. -- Regards, Jake Marx MS MVP - Excel www.longhead.com |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel 2003 - Different Header for each page | franklyorange | Excel | 0 | 08-26-2008 02:26 PM |
| Powerpoint 2003 - slides with Excel text | franklyorange | PowerPoint | 0 | 08-19-2008 09:30 AM |
Run Outside application from toolbar button
|
Richard Harison | Word | 3 | 12-20-2005 03:22 PM |
Application not found error when trying to open .pdf files.
|
Dave | Outlook | 2 | 12-15-2005 01:01 PM |
access runtime application will not install
|
markjean | Office | 1 | 12-06-2005 02:15 AM |