Hello
I am sending an email with an attached workbook. Curently I have the recipient open the email and click a button I have placed on the worksheet that runs a macro that deletes the button from the worksheet and saves the workbook to a specific folder.
This is working fine. However, I have the need to send more than one workbook and want to know if I can do basically the same thing but have one macro open and save all the attached workbooks without having the recipient open each attachment seperately.
Here is the macro I am currently using. I know I am a novice at this so please be kind.
ActiveSheet.Shapes("saveto").Delete
Application.DisplayAlerts = False
Sheets("data").Select
ActiveWorkbook.SaveAs Filename:="p:\price data\locdata.xls"
ActiveWorkbook.Close
I am currently using office 2003
Thank you
I am sending an email with an attached workbook. Curently I have the recipient open the email and click a button I have placed on the worksheet that runs a macro that deletes the button from the worksheet and saves the workbook to a specific folder.
This is working fine. However, I have the need to send more than one workbook and want to know if I can do basically the same thing but have one macro open and save all the attached workbooks without having the recipient open each attachment seperately.
Here is the macro I am currently using. I know I am a novice at this so please be kind.
ActiveSheet.Shapes("saveto").Delete
Application.DisplayAlerts = False
Sheets("data").Select
ActiveWorkbook.SaveAs Filename:="p:\price data\locdata.xls"
ActiveWorkbook.Close
I am currently using office 2003
Thank you
