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.