Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to "saveas" the active workbook and would prefer to have the
system enter throught he prompt that the file exists and do i want to replace it? In this particular case, I always with to replace it. My current is as follows: ActiveWorkbook.SaveAs (conSaveFilePath & strRespFileName) conSaveFilePath is a file path constant and strRespFileName is a variable containing the file name. Or...should i be dealing with this differently? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Confused here Prevent Saving File - but allow ONLY File SAVEAS Met | Excel Discussion (Misc queries) | |||
IF File Exists | Excel Programming | |||
File already exists | Excel Programming | |||
SaveAs command when a file already exists? | Excel Programming | |||
the file already exists - do you want to replace the existing file? | Excel Programming |