![]() |
|
|
|
#1
|
|||
|
|||
|
I tried your code as a .vbs script and excel closed for me.
In fact, I thought maybe there was a prompt waiting for you so the xlwkb.close line was still waiting. If you have a volatile function (like =today(), =now(), =rand()), then that workbook will recalculate when you open it. And maybe excel was waiting for you to answer the "The workbook has changed--do you want to save it?" prompt. But that message popped up nice and clear when I tested. (You would have noticed it.) Maybe adding xlapp.visible = true to your script would help you find the problem. (tested with winxp home and xl2003) |
|
|
|
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 |