Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automatically close all Excel workbooks without saving
Message
 
To
11/01/2005 19:51:40
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00976227
Message ID:
00976279
Views:
18
Thanks Randy! How could I iterate through all the workbooks to close them all without saving changes?

>>How to automatically close all Excel opened workbooks without saving it?
>>
>>I would like to do this in the finally section in the try-catch block before quiting Excel so that it would get stuck with an "Do you want to save your workbook?" Dialog.
>>
>>Thanks!
>
>If you pass .F. as the first parameter of Close() as in Workbook.Close(.F.) you should avoid the dialog. Same is true for Word documents.
>
>-- Randy
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform