Hi,

I'm not versed in VBA, or very experienced with excel for that matter, but wondering if there is some script that would save the current workbook to another directory automatically when the workbook is saved?

Currently my boss updates a master workbook and then emails me to load it to our servers (basically, another file directory) by copy/paste. He does this frequently so I'm trying to save some time by automating the process.

Any help would be appreciated. Thank you.

Brian