VBA Code to SaveAs file in one location, and backup to another location

Hello,

I have a code where when user selects SaveAs, it will automatically direct the user to the intended path and intended filename populated in saveas dialog box.

How do I save a copy to another location using the same function? So it will have 2 copies living in 2 separate directories?

I am assuming i have to run SaveAs and Save simultaneously but cant figure this out to save my life so some help would be greatly appreciated.

Please Login or Register  to view this content.

Thanks for ur reply. The filename stays the same....so where would i put the code you suggested? As another private sub function? Or does it go in current private sub.

Great! Thanks for ur help. I will try this as soon as i get home in a few

Thank you so much Mike, you guys are great.

It wasnt working as intended at first because the SaveAs box came up twice, but i wiggled the code a bit to say SaveCopyAs and its working as intended. I really appreciate your help leading me on right path!

Please Login or Register  to view this content.

well, i spoke too soon. This indeed works, it works because the first time, when user selects SaveAs it will save and make a copy. However, when the user opens the file again and user would select 'save', it will save the original file but it will not save over the copy in back-up folder.....what am i missing? Do i need to trigger something for Save?

Please Login or Register  to view this content.