Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My issue is with Exel 2000, more used to Access than Exel
so bear with me! Have the following simple code to save a spreadsheet which works fine as long as the file name being saved to doesn't already exist. ActiveWorkbook.SaveAs Filename:= "C:\Test.XLS", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, _ CreateBackup:=False Really need to handle this gracefully and not just return an error code to the user. Any help would be appreaciated. Regards Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checking to see if a file exists. | Excel Discussion (Misc queries) | |||
Checking if Sheet Exists? | Excel Discussion (Misc queries) | |||
Checking to see that a CHART exists prior to running a simple command | Excel Discussion (Misc queries) | |||
Checking to see if Folder exists | Excel Programming | |||
Checking 2 c if workbook exists | Excel Programming |