megha
02-08-2011, 09:27 AM
I am using the following code to SaveAS my workbook at the same location with the same file name. In other words - Workbook.SaveAs command that automatically overwrites a file with the same file name without prompting for a overwriting the file. This code works fine on my “c” drive but do not work on the website. I would appreciate any help. Thank you so much.
Private Sub CommandButton1_Click()
Application.DisplayAlerts = False
ThisWorkbook.SaveAs Filename:= "http://sptdsrefining.etc. etc. Work List.xls (http://sptdsrefining.etc.%20etc.%20work%20list.xls/)"
Application.DisplayAlerts = True
ActiveWorkbook.Close
End Sub
Private Sub CommandButton1_Click()
Application.DisplayAlerts = False
ThisWorkbook.SaveAs Filename:= "http://sptdsrefining.etc. etc. Work List.xls (http://sptdsrefining.etc.%20etc.%20work%20list.xls/)"
Application.DisplayAlerts = True
ActiveWorkbook.Close
End Sub