Using ActiveWorkbook.SaveAs

[jeffhanner10@gmail.com]

Hi,
I am using the following code "segment" in one Excel Workbook to save over an existing ExcelReady.xls file. If I run this code in Excel, when it get's ready to save it prompts me as to whether or not I want to write over the existing file and I click on Yes. Everything thing works in the VBA code.

Now when I Run the Excel Macro from Access it stops when it is going to overwrite and doesn't allow me to continue. If I hit escape, then it comes up with a message to Switch and then it seems to work.

So, I've tried adding some arguments to SaveAs code but nothing works.

Here is the code I'm using. I want it to automatically overwrite the ExcelReady.xls file.



ActiveWorkbook.SaveAs fileName:="V:\Excelready.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
ActiveWorkbook.Save

Any help is appreciated.

[June7]

Review https://stackoverflow.com/questions/...atic-overwrite