Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as and file exists.
I am running some code to save a file. I am passing the filename as a variable (not important really)
However I want to be able to invoke some action if the file exists. In particular action to respond to the No and Cancael options from dialog What do I add to my code to do this Barr afID = Worksheets("Form-E").Range("J1" myPath = ThisWorkbook.Path & "\My PAFs\" & PafID & ".xls ActiveWorkbook.SaveAs Filename:=myPath, FileFormat:= xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False , CreateBackup:=Fals |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as and file exists.
You'll have to roll your own BeforeClose event, as shown by John Walkenbach:
http://j-walk.com/ss/excel/tips/tip78.htm -- Vasant "Barry" wrote in message ... I am running some code to save a file. I am passing the filename as a variable (not important really). However I want to be able to invoke some action if the file exists. In particular action to respond to the No and Cancael options from dialog. What do I add to my code to do this? Barry afID = Worksheets("Form-E").Range("J1") myPath = ThisWorkbook.Path & "\My PAFs\" & PafID & ".xls" ActiveWorkbook.SaveAs Filename:=myPath, FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Test if file exists | Excel Discussion (Misc queries) | |||
Determine if a File Exists | Excel Discussion (Misc queries) | |||
File Exists | Excel Discussion (Misc queries) | |||
the file already exists - do you want to replace the existing file? | Excel Programming | |||
Checking if file exists in VBA | Excel Programming |