Pleasant evening, I need help in creating a macro that has the options through command buttons to print the current employee payslip or printing all employees payslips from the payroll database. I am new to VBA programming, any help will be greatly appreciated. Attached is a copy of the excel spreadsheet. Thank you in advance for any assistance.
Last edited by Keith Rauseo; 11-17-2018 at 05:45 AM.
It's of no help if you have to log in and don't have the particulars.
Sorry about that, all login particulars removed. Again thanks for any assistance.
Sorry about that, all login particulars removed. Again thanks for any assistance.
How is the "current employee" determined?
This should save all Payslips to .PDF files in the same Folder that houses your excel workbook.
Change the pdf routine to printing to your printer if you want that.
Please Login or Register to view this content.
The current employee is determined by entering the Employee number. Thank you very much for your quick response. I got the following error message when running the macro.
When you get the error, which line is highlighted?
I have not tried it on your attachment yet.
One thing you have to do is change the sheet called "PaySlip" (Capital S) to "Payslip" and don't change anything in the code or in the code change "Payslip" to "PaySlip" and don't change the sheet name.
Last edited by jolivanes; 11-17-2018 at 08:02 PM. Reason: PaySlip problem
Staying with the same type of code, this should work for a single employee.
Please Login or Register to view this content.
Thanks again jolivanes, I made the change to the PaySlip sheet name as indicated, the attached photo shows the highlighted area where the error message occurs.
Do you have the "Create PDF Document" capability on your Excel?
https://www.microsoft.com/en-us/down...ails.aspx?id=7
If not, download/install it if you want it otherwise delete all of it and print to your local printer.
@ jolivanes
OP Office version says 2007 so exporting shouldn't be a problem.
I suspect it's rather a name issue.
PS
On my system it works flawlessly.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi Rudi (that's what it is, isn't it?)
I do not remember if it is automatically part of 2007 or not. That's why I mentioned it.
I also have not mentioned yet what I think of pictures! After all, Keith is pretty new (5 posts) to all of this.
I do not know if his file is on an external system and if it is if that could create the problem.
I guess these are questions that Keith has to answer for us. Maybe I never should have suggested to print to PDF but I prefer it myself.
He can, as suggested, delete all of that and print whatever names are on the sheet. I would suggest to copy a bunch away from Column A so you don't print 100 pages just to try code.
Thanks Jolivanes, I downloaded the SaveAsPDF.exe, which resolved the error message. Both sub routines worked and payslips generated. All formulas from the payslip sheet are overwritten when the macro is run as the only issue. Is there a way of preventing that from happening?
Please Login or Register to view this content.Both of course save as PDF files. I assume you know what to do if you want it printed directly to your printer.Please Login or Register to view this content.
Jolivanes, macro works perfect. Project solved. Thank you, Thank you very much. Hopefully I will be able to contribute in the near future.
Thank you for letting us know.
Good luck
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks