|
-
Jun 30th, 2002, 09:40 PM
#1
Thread Starter
PowerPoster
closing an excel file opened in VB
I open an excel file, stuff in some data, close it and kill it.
everything works fine but the close process brings up a system messge asking if I"d like to save the changes. I'm sure that I've seen a way to make the close process tell the system to save without asking, but now I can't find that technique anywhere in
the on-line help, so if anyone knows it, I'd appreciate the syntax.
my close is just:
xlApp.Workbooks.Close
and I think it can be something like
xlApp.Workbooks.Close vbSaveWithoutAsking
(you get the idea)
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|