Saving WB too two different Locations

[derek davis]

Hello guys I can't seem to find how to save a 2007 workbook too two different locations, OneDrive and F:\ . I would like to operate this macro on the activation of the return key. One thing I don't want to bother with is when the macro is run a reminder msg "do you want to overwrite an existing file with the same name". I only want the macro to run on this workbook. I not sure if this is possible, can anyone help me? Thx

 

[Marc L]

Hi,​

​

for each location use the SaveCopyAs method …​

To not have the message you may need to first set the DisplayAlerts property to False.​

Set it back to True before the procedure ends …​

​

 

[derek davis]

Hi Marc L, thanks for responding to my call for help. I am trying to get away from the conventional way of saving the file. Thats why I wanted the return / enter key to activate the macro and that would do all the work in the background..
Thanks