LinkBack URL
About LinkBacks
I want generate All Employee payslip in PDF on 1 Button=VBA codes gives error PLS HELP
I want generate All Employee payslip in PDF on 1 Button=VBA codes gives error PLS HELP
Last edited by anjanmb; 12-31-2022 at 07:46 AM.
You can't really excpect to get much help when you haven't posted any code for us to review.
Please also read Excel Forum's Duplicate-Posting policy in rule 5: http://www.excelforum.com/forum-rule...rum-rules.html
That aside, see: Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks page at: https://www.msofficeforums.com/mail-...ps-tricks.html
For the mailmerge basics, see: https://support.microsoft.com/en-us/...f-932c49474705
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
How do you expect any help without a file ?
Please see the yellow banner at top of the page on how to attach a sample workbook.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Sorry my Excel file just now uploaded with code. actually previously it couldnt uploaded. Now you can check it. Thx for your reply
Thx for your reply , Sorry my Excel file just now uploaded with code. actually previously it couldnt uploaded. Now you can check it.
Since you have uploaded an xlsx file - which can't include VBA code - we still have no idea what code you're using. Please post your code.
VBA Code is as under:
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. I also corrected your "smart" quotes to standard quotes so the code will be valid. --6StringJazzer
Please Login or Register to view this content.
Last edited by 6StringJazzer; 12-30-2022 at 09:06 AM.
I have closed your parallel (and largely empty) thread. Please upload a file WITH the code in place. Please don't expect us to have to do this for you.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
That code bears no apparent relationship to the workbook you attached. The code references worksheets named "Salary" and "Paystubs", but those sheets don't exist in the workbook. So, if that's the macro you're running, it's no wonder you're getting errors.Originally Posted by anjanmb
I would like to inform you that I am new in this forum. I am searching on google for my problem so I had just login to solve it. Secondly I had attached again the UPDATED excel file in which the VBA code is pasted on next sheet which please check and help me if possible.
Did you even bother reading my last post?
if you can correct it or create it with your knowledge then i will be oblige.
It seems to me that you've taken someone else's workbook, renamed their worksheets and changed the layout of their payslip page, and now you want us to correct the mess you've made for yourself - all without you making any effort to fix even such basic problems as the code references I've told you about. Not interested.
anjanmb,
VBA is not normally just a formula that you can paste in a cell and call it good.
If you open up the Macro and paste it into a new workbook most of the time it will not work.
VBA references sheets, and columns and ranges specific to a unique workbook.
If you don't have a sheet named to what the VBA is referencing, it will give you an error. There are way too many "fixes" that would need to be done
and at that point, we would be doing the work for you. If you want to hire someone to make a Workbook with working VBA, that's one thing.
But we wouldn't know where to start to "fix" a code even if we wanted to.
This is like saying "I'm trying to fix my cake" and the recipe you have is for Meatloaf.
In this case, that's not true. Indeed, I've already given anjanmb very specific advice about the sheet referencing errors in his code that anyone could fix. See post #9.
Now cross-posted at: https://chandoo.org/forum/threads/wa...d-email.50423/
Kindly read Excel Forum's Cross-Posting policy in rule 3: http://www.excelforum.com/forum-rule...rum-rules.html
Thanks , good guidelines you have shared. Actually I m now aware about VBA / Macros. but I had tried by watchin youtube videos and tried it. So some where I am failed so in more search I found your website so think to take help in next step by solving the errors in my worksheet VBA Code.
Please guide me in this website I can get help or I have to try other ways ? Only chats and replies does not solve my query.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. As you are new gere, I shall do this for you this time: https://chandoo.org/forum/threads/wa...d-email.50423/ and here: https://learn.microsoft.com/en-us/of...5-apps-by-date)
Last edited by AliGW; 01-02-2023 at 04:17 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
And here:
https://forum.ozgrid.com/forum/index...28#post1259228
Since you have copied this ALL over the place... Is it cross-posted ANYWHERE else?
NO FURTHER HELP to be given until we get a complete list of all cross-postings from the OP.
No accept chandoo.org
You have not answered my question. The thread remains CLOSED, until you tell me that it NOT X-posted anywhere else.
Yes it will not posted until the thread will closed.
But my question was also unanswered which was posted on 01/01/2022 12.04pm.
You clearly do not understand. I will try one time more.
No-one is allowed to answer YOUR question until YOU answer MINE.
The same Q is posted at Chandoo, Ozgrid & Microsoft.
Have you cross-posted the same question in other places? If so, WHERE?
Not posted else any where.
Why Didn't get reply? This website is only for Chatting or should I assume that here nobody capable.to do so ?
I did not see your reply.
THREAD OPENED.
check thread :24
Check Post 26. What does it say there???
Thread open.
Can it be any plainer??
Last edited by Glenn Kennedy; 01-10-2023 at 07:15 AM.
See here:
https://www.automateexcel.com/vba/save-print-pdf/
Attached has example from the above
Thx Jhon Topley, for your help
As per my Thread #1 I want all employee salary slip on 1 single click of button.
Can you update it and send me. ?
Please Login or Register to view this content.
You will to change RED highlighted for patname/file name
Thx John , Execellent ... It runs good. One more question. can I email the Each PDF to particular Email ID from excel only from 1 single button ?
I have never tried to do this but attached is sample code using OUTLOOK
https://www.extendoffice.com/documen...and-email.html
On on our forum, couple days ago, check:
https://www.excelforum.com/excel-pro...ml#post5783536
especially my last post about attachment.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks