After creating a macro, I am not able to open the new file saved

Copper Contributor

Hi ,

al can you please help me?

 

I open an excel, I clicked on "Macro" and saved the new file. I clicked on this and a warning message appeared (notice: I didin't inserted "_" and any spaces in the file name)

"Excel cannot open the file ’20200428Productsb2b.xlsx’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

 

Thank you a lot,

Ilaria

1 Reply

@Ilaryg_89 You can try below ways:

 

Workable Solutions Step-by-step Troubleshooting

Fix 1. Change File ExtensionOpen Microsoft Excel and go to "File" > click Export and choose Change File Type.
Fix 2. Open in Safe ModePress Windows+R key, type: excel.exe /safe and click "OK" > Save the file as .xlsx...
Fix 3. Use Open and RepairStart Office Excel > click File and Open > select the inaccessible Excel file...
Fix 4. Recover from previous versionRight-click the inaccessible Excel document and choose "Properties" > Open the "Previous Version".
Fix 5. Recover from autorecoverOpen Office Excel and got to "File" tab > Open the file in Excel and click "Restore"