SaveAs Error 1004 when replacing

Hi,

I'm creating a new Excel workbook, and saving it to a specific location.

When I remove all the other variables, here's the scenarios I'm running into:
1. [Success] - Save new Excel workbook
2. [Success] - Replace existing Excel workbook and prompt user to replace
3. [Fail] - Replace existing Excel workbook and do not prompt user
4. [Success] - After failing above, replace existing Excel workbook and do not prompt user

Please Login or Register  to view this content.

The only thing I can think to handle this would be to trap the error and try to save again, but I'd like to understand why it's erroring out.

Hi,

I had this issue once and resolved it by doing the following.

When the "SaveAs" dialog box appears there is a checkbox asking the user for comformation.

I unchecked the box and it never prompted me again.

colmckenzie

This file will be deployed to a lot of individuals, so that's not an option for me. Does anyone else have a solution?

yawnzzzz,

According to Microsoft....

This error message occurs when the following conditions are true:

The Lock project for viewing option is selected in the Visual Basic for Applications project.

-and-

You run a macro that uses the .SaveAsmethod and the FileFormat argument is set to xlText


See here.

http://support.microsoft.com/kb/199268/en-us

cplmckenzie