Run time error 1004

[clarke24]

Hi, i have ritten some code t save an xlsm file as an xlsx file. It was working fine then all of a sudden started giving the error 'Run-time error '1004': Method 'SaveAs' of object'_Workbook' failed.

It does create and save the file in xlsx format but throws up the above message.

Please Login or Register  to view this content.

Any help would be greatly apreciated.

[CheeseSandwich]

Usually when you use saveas you would define a path to save the file to. In your code above you are saving the file as just a file name. You need to include the path to the save location as well as the name to save the fle as.

For example:

Please Login or Register  to view this content.