Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command to bypass the asking to save option
I am good on this stuff, just stuck on the bold portion.. Open a file on the network (works fine) Find a tab in the file and copy it (works fine) Open a new workbook and past the tab (works fine) *Close the original file on network workbook and move to th next…..Here is where the issue lies, when we try and close the fil that we just copied from it asks the user if we want to save, well w don’t want the user to have to answer no, we just want the code to sa no and continue to loop on forward.. -- yazman0 ----------------------------------------------------------------------- yazman08's Profile: http://www.excelforum.com/member.php...fo&userid=2518 View this thread: http://www.excelforum.com/showthread.php?threadid=38674 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command to bypass the asking to save option
Activeworkbook.Close SaveChanges:=False
-- Regards, Tom Ogilvy "yazman08" wrote in message ... I am good on this stuff, just stuck on the bold portion.. Open a file on the network (works fine) Find a tab in the file and copy it (works fine) Open a new workbook and past the tab (works fine) *Close the original file on network workbook and move to the next...Here is where the issue lies, when we try and close the file that we just copied from it asks the user if we want to save, well we don't want the user to have to answer no, we just want the code to say no and continue to loop on forward.. * -- yazman08 ------------------------------------------------------------------------ yazman08's Profile: http://www.excelforum.com/member.php...o&userid=25187 View this thread: http://www.excelforum.com/showthread...hreadid=386749 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as .xla option is not coming when I try to save | Excel Discussion (Misc queries) | |||
Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
No Save As option | Excel Discussion (Misc queries) | |||
Specify a default file name in VB when the Save / Save As command. | Excel Programming | |||
Command/option/spin button - no control menu available | Excel Programming |