Save workbook to speciifc path

Hello everyone
I need to fix the following code that open dialog to specific path to save a copy of the file in

Please Login or Register  to view this content.

I got error at this line

Please Login or Register  to view this content.

Any ideas?

I didn't get an error there, I got one at the

Please Login or Register  to view this content.

I commented it out, and the code seemed to run fine after I did.

I commented this line out too

Please Login or Register  to view this content.

and still get the error at this line

Please Login or Register  to view this content.

Thanks for help

I am working with a blank sheet, that might be the reason I don't get an error at that line.
Maybe move the .Execute to the next line and add an End If after it. And/or, you might need and else statement after the .Execute line, like Else Exit Sub maybe?
Here is the code with the Else If added

Please Login or Register  to view this content.

Thanks for offering help but it is still the same error

Hmmmmm. Maybe attach a sample of your workbook with the code so I can offer more concrete help?