XL97: Run-time Error '1004' Saving Workbook as Text

• Microsoft Excel 97 for Windows

SYMPTOMS

When you run a Visual Basic for Applications macro that saves a workbook as text, you may receive the following error message:

Run-time error '1004':

Method 'SaveAs' of object '_Workbook' failed"

CAUSE

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 .SaveAs method and the FileFormat argument is set to xlText

WORKAROUND

To work around this problem, unlock the workbook before running the macro. To do this, follow these steps:

1. Open the workbook that you are trying to save as text.



2. Press ALT+F11 to open the Visual Basic Editor.



3. On the Tools menu, click VBAProject Properties, and then click the Protection tab.



4. Click to clear the Lock project for viewing check box. Click OK.



5. On the File menu, click Save. Press ALT+Q to return to Excel.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL97

Keywords : kbdta kbdtacode
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug