• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

macro to convert excel files to password protected pdf files

V

VinodN

New Member
Hi,

I am Vinod working as an ops. manager in a BPO.

I have a macro for generating payslip backups in pdf format from worksheet. However, I require the pdf files generated to be password protected. The passwords have to be different for each backup. Also, the excel spreadsheet containing the data will also have the set of passwords for each employee.

Is there any script that I can include in my current macro which will pick up the password from the database and assign it to the respective files while converting it in pdf format.

Help will be really appreciated.

Regards,
 
Last edited:
Thanks for the link. Had already checked this.
It mentions use of pdf creator but I was looking for a macro directly without using a pdf utility. Currently, my macro gives me an output in pdf file which gets saved on the drive directly. I just want to add different passwords setting script after the macro converts the excel into pdf file.
 
You must log in or register to reply here.
Back
Top