Error 1004 in Excel Macros

[Francisco Paz V]

I have an excel file using macros inside. The file was created on Excel xls version (97-2003).
The problem now is, when I tried to run the system dont find the file.
The message said: Runtime error "1004" has occurred. Microsoft excel cannot access file xx.xlsm

 

[chris smith5]

Hi Francisco Paz,

Excel Runtime Error 1004 is a common error that occurs when a macro-enabled Excel file is running on an older version of Microsoft Office or when the Excel file contains corrupt or invalid data. Here are some steps you can try to fix this error:

1. Check the file path: Ensure that the file path you are using to access the Excel file is correct. If you are using a relative file path, make sure that the file is located in the correct folder relative to the current location.
2. Check file permissions: Ensure that you have the necessary file permissions to access the Excel file. Check with the system administrator or the owner of the file to ensure that you have the correct permissions.
3. Repair the Excel file: If the Excel file is corrupted, try repairing the file using the built-in repair tools in Excel. To do this, open Excel, click on "File" and then "Open." Next, select the file that is giving you the error and click on the drop-down arrow next to "Open." Select "Open and Repair" and choose the appropriate option.
4. Enable Macros: If the Excel file contains macros, make sure that macros are enabled in Excel. To enable macros, click on "File," then "Options," then "Trust Center," and finally "Trust Center Settings." Click on "Macro Settings" and select "Enable all macros."
5. Convert the file to the current Excel version: If the file was created in an older version of Excel, try converting the file to the current version of Excel to ensure that it is compatible with the current version.

Hopefully, this should work out for you.

Best Regards.