LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default workbook.close savechanges:=True problem

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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA - Do Loop or SaveChanges = false Dan Excel Discussion (Misc queries) 1 January 23rd 09 05:54 PM
Close workbook with "Cancel=TRUE" in the BeforeClose()" Wellie[_3_] Excel Programming 1 October 16th 04 09:46 PM
When running workbook.close True Excel generates an error!!! Daniel[_10_] Excel Programming 2 May 11th 04 05:31 PM
close(savechanges,filename,routeworkbook) Zygoid[_11_] Excel Programming 2 January 31st 04 06:06 PM
how to recognize SaveChanges Parameter Guido Buecker Excel Programming 1 September 17th 03 01:30 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"