Thread
:
workbook.close savechanges:=True problem
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
workbook.close savechanges:=True problem
Dave
As I presume you are using automation across office or even from another
language, you could try
xlApp.DisplayAlerts=False
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Dave the Wave" wrote in message
...
Hi:
I have a workbook that opens up other workbooks, transfer some data, then
closes the workbook using VBA.
VBA Closing statement:
wbkAnnual.close SaveChanges:=True, Filename:="BlahBlah.xls"
note: wbkAnnual is a workbook object
According to the documentation I've read, including the "savechanges:
=filename" text to the close command prevents the "Save Changes Yes/No"
dialog window from appearing. I vaguely remember this method working
before, but not on this present workbook. Every time a workbook is closed
by VBA the "Save Changes" dialog window appears.
Is there a condition/s that overrides the "savechanges:=True" command?
Does this only apply when the book being closed is the one that contains
the VBA code?
Any information will be greatly apreciated. Thanks!!
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge