macro to save as stopped working

[jwilliams919]

We have had this macro for a while now and lately I get a error on the below when running . Do you guys have any recommendations?



ActiveWorkbook.SaveAs Filename:=CompleteFilename, FileFormat _
:=xlOpenXMLWorkbookMacroEnabled, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
False, CreateBackup:=False

 

[MrKowz]

Welcome to the forums!

What error are you receiving? When you hover over the CompleteFilename variable, what value is being returned?

 

[jwilliams919]

Welcome to the forums!

What error are you receiving? When you hover over the CompleteFilename variable, what value is being returned?

Its tool long of a value to read but appears to go to my shared drive the original file is in

 

[jwilliams919]

I see i cannot delete a post lol

Sorry about the above but it shows a network drive location and i get a runtime error 1004 Method "saveAS' of object_workbook'Failed

 

[MrKowz]

Run the code until you get the error, then load up the Locals Window in VBA (View>Locals Window). You should be able to find your variable in this list. In the "Value" column, you can click in here and view/copy the value out. My guess is that the code is erroring because it is either an invalid file path or it has an invalid file extension.