Export sheets to new files and email
Posted on 2012-04-07
Our accounts team keep an excel 2010 (running on win7) workbook up to date with various information that needs to be shared with managers. We also use outlook/exchange internally
Each manager has his/her own sheet, and it needs to be mailed to them as a separate sheet in it's own workbook. (they currently do this by copy pasting. it takes about 8 hours a week!)
Using Excel's vbs would it be possible to export this info to separate excel workbooks and then email them?
I was thinking that the logic could follow:
Get all sheets, then for sheets that end in @ (e.g. bob.smith@) export the sheet to it's own new excel workbook and then
save that workbook as bob.smith.xslx in a predefined folder
or even better:
generate a new mail message to email@example.com. with the sheet as an attachment.
The only problem is I have no idea where to sart with excel vbs and I was hoping that someone on here may have solved this type of problem before, and could lend a hand :-)