[Subscribe to Daily Digest] |
![]() | [Main General Bulletin Board | BBFAQ |
Prev by Date | Next by Date | Post Followup ]
Member Login / Signup - Members see fewer ads. - Latest Member Gallery Photos
Any Excel macro experts here? Posted by Rod [Email] ![]() ![]() |
I am trying to automate a process that I do every week. As treasurer of a small non-profit animal shelter in my spare time I am responsible for calculating our weekly payroll. I have a spreadsheet that does the payroll calculations then puts the numbers on to a pay stub for each employee. Because I don't want to email the whole spreadsheet to the shelter manager each week (it's a large file), I have developed a simple macro that copies the pay stub information from my main file to a single worksheet file, with values instead of calculated numbers so it no longer needs to be linked to the original data. I then email this one worksheet to the shelter manager who distributes the pay stubs to the employees.
I also save a PDF of the file so we have copies of the actual paystubs on file. It's this part I'm having trouble automating since I want to save it with a different name each time. I call it "Paystubs 2-25-07" or whatever the pay period date is. I managed to get the title of the file in a cell in the workbook but I haven't figured out how to make it save the file as this name. I tried copying and pasting, but as soon as you hit "Save As" or "Print to PDF" the text you copy disappears from the clip board. I'm sure there must be a way of doing this?
Thanks
Rod
No Site Registration is Required to Post - Site Membership is optional (Member Features List), but helps to keep the site online
for all Saabers. If the site helps you, please consider helping the site by becoming a member.
![]() |
![]() |
![]() |
![]() |
![]() |