Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close file without saving
Tom Ogilvy Wrote: You say excel then doesn't close the file. From your description, it sounds like you are getting the prompt for file different from the one you intend to close. You need to look mor closely at how you are referencing the file. I have never seen a prompt from workbooks(sourcename).Close SaveChanges:=False There wouldn't be much point in having the SaveChanges Argument sinc it is provided to answer that question. -- Regards, Tom Ogilvy Hi Tom, Thanks for your reply. Actually the message is 'Do you want to save th changes you made to 'data280.xls'?', which is the file I want to close In the past, just 'Workbooks(sourcefilename).Close' in combination wit 'Application.DisplayAlerts = False' worked fine. When it didn't work i the new macro, I changed it in 'Workbooks(sourcefilename).Clos SaveChanges:=False'. But whatever I try, it just doesn't work anymore. Regards, Anne -- Roadi ----------------------------------------------------------------------- Roadie's Profile: http://www.excelforum.com/member.php...nfo&userid=593 View this thread: http://www.excelforum.com/showthread.php?threadid=27153 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If I close a file without saving changes, can I get the autosaved | Excel Discussion (Misc queries) | |||
File/Close automatically saving changes without prompt | Excel Discussion (Misc queries) | |||
Am i the first person to close and excel file, without saving chan | Excel Discussion (Misc queries) | |||
Close file without saving | Excel Programming | |||
Close file without saving data | Excel Programming |