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 firstname.lastname@example.org. 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 :-)
Managing Active Directory does not always have to be complicated. If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.