Hi there,

I need some help please. This below script has worked perfectly before but for some reason I keep getting an error now.

Runtime error 1004: Method ‘SaveAs’ of object ‘_workbook’ failed.

When I debug through the code the error is on the ActiveWorkbook.SaveAs code.

Any ideas what it could be?

When the user clicks SaveAS, I want to force the current Macro enabled workbook to be saved as a non-macro file in the users chosen filepath.

Many thanks


Please Login or Register  to view this content.