Wibble_
asked on
Export sheets to new files and email
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
either:
save that workbook as bob.smith.xslx in a predefined folder
or even better:
generate a new mail message to bob.smith@domain.local. 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 :-)
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
either:
save that workbook as bob.smith.xslx in a predefined folder
or even better:
generate a new mail message to bob.smith@domain.local. 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 :-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER