Using Variables in SaveCopyAs?

Hi all

This is my current code I use to backup my sheet while I am working

Please Login or Register  to view this content.

I need to change my name to the variable like %username% in windows so that it would work for any users computer. Also curious if it is possible to make it create the "My Sheet Backup" folder if it does not exist already, instead of throwing an error.

I tried "Application.UserName" but that gave me "James Pyle" instead of "jpyle"

Thanks in advance

Try Envrion function like below...

Please Login or Register  to view this content.

So the Environ("UserProfile") part replaces the C:\Users\jpyle part.

Glad it worked.
Thanks for the feedback.