Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
ThisWorkbook.SaveCopyAs Filename:="C:\Folder\XXXXX-" & inputText &
".xls" however if the file already exists I get an error "1004". I presume I require something like If 'ThisWorkbook exists' Then 'overwrite the existing file' Else ThisWorkbook.SaveCopyAs Filename:="C:\Folder\XXXXX-" & inputText & ".xls" End If Can anyone help with the required syntax for 'ThisWorkbook exists' and 'overwrite the existing file' - or if there is a better option. Many thanks in advance. Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem | Excel Programming | |||
Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem | Excel Programming | |||
"Save" macro problem, still prompted to save when closing workbook (?) | Excel Programming | |||
Problem when attempting to save Workbook with VBA project protected | Excel Programming | |||
Save Workbook Problem | Excel Programming |