Question: File already exists
 

Hello Everyone,

I have written a macro so that it formats some code, creates another
workbook, and then saves the code to the harddrive. It all works fine, but
I want to save it to the same file name everytime. Is there a command that
I can write that will AUTOMATICALLY save the file and overwrite the file???
After the script runs, then a msgbox pops up and always asks, "calander.csv
already exists, do you want to overwrite??" Can I write some code that will
do that? Here is the code I have now:

ChDir "C:\Program Files\InternetMacros\Downloads"
ActiveWorkbook.SaveAs Filename:= _
"C:\Program Files\InternetMacros\Downloads\calander.csv",
FileFormat:=xlCSV, _
CreateBackup:=False

Any help would be greatly appreciated,

Michael Vaughan

Question: File already exists
 

application.displayalerts=false
'your code here
application.displayalerts=true


Michael Vaughan wrote:

Hello Everyone,

I have written a macro so that it formats some code, creates another
workbook, and then saves the code to the harddrive. It all works fine, but
I want to save it to the same file name everytime. Is there a command that
I can write that will AUTOMATICALLY save the file and overwrite the file???
After the script runs, then a msgbox pops up and always asks, "calander.csv
already exists, do you want to overwrite??" Can I write some code that will
do that? Here is the code I have now:

ChDir "C:\Program Files\InternetMacros\Downloads"
ActiveWorkbook.SaveAs Filename:= _
"C:\Program Files\InternetMacros\Downloads\calander.csv",
FileFormat:=xlCSV, _
CreateBackup:=False

Any help would be greatly appreciated,

Michael Vaughan

--

Dave Peterson

Question: File already exists
 

ChDir "C:\Program Files\InternetMacros\Downloads"
Application.displayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
"C:\Program Files\InternetMacros\Downloads\calander.csv",
FileFormat:=xlCSV, _
CreateBackup:=False
Application.DisplayAlerts = True

or
Dim sStr as String
ChDir "C:\Program Files\InternetMacros\Downloads"
sStr = "C:\Program Files\InternetMacros\Downloads\calander.csv"
On Error Resume Next
Kill sStr
On Error goto 0
ActiveWorkbook.SaveAs Filename:=sStr, _
FileFormat:=xlCSV, _
CreateBackup:=False

--
Regards,
Tom Ogilvy


"Michael Vaughan" wrote in message
. ..
Hello Everyone,

I have written a macro so that it formats some code, creates another
workbook, and then saves the code to the harddrive. It all works fine,
but
I want to save it to the same file name everytime. Is there a command
that
I can write that will AUTOMATICALLY save the file and overwrite the
file???
After the script runs, then a msgbox pops up and always asks,
"calander.csv
already exists, do you want to overwrite??" Can I write some code that
will
do that? Here is the code I have now:

ChDir "C:\Program Files\InternetMacros\Downloads"
ActiveWorkbook.SaveAs Filename:= _
"C:\Program Files\InternetMacros\Downloads\calander.csv",
FileFormat:=xlCSV, _
CreateBackup:=False

Any help would be greatly appreciated,

Michael Vaughan

Thanks
 

Thanks Dave and Tom!!
:-)