Saving a Copy of an Active Workbook to a different folder (With Full Admin Rights)

[hans302]

Hi - I have the following code that is supposed to create a Copy as a Backup of the Active Workbook and Save it to a different folder. (See image after the Code for the Error Message)

Hope someone can assist?
Many thanks
Hans302

Please Login or Register  to view this content.

Image3.jpg

[Trebor76]

Hi Hans302,

It's the colon : you have for the time stamp - this is an invalid character when saving a file. Change it to something else and try again (note the file extension has to be same when using SaveCopyAs).

Robert

[AC PORTA VIA]

How about this

Please Login or Register  to view this content.

[hans302]

Thanks AC - Works just great !!

I changed the code to make it more readable in the folder to........

Please Login or Register  to view this content.

Works perfectly and also added VBA to check if the correct folder exists, and if not, to create it..... Using.....

Please Login or Register  to view this content.

[AC PORTA VIA]

Glad it works for you