Excel VBA PDF password.

Sanjay Gandhi
Sanjay Gandhi used Ask the Experts™
on
Hi,

I want to apply password to PDF file while saving PDF file using VBA code. What will be the code for this?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
You can do this with MS Word but the option is not available for Excel. Strange!
Sanjay GandhiFounder, Kenhal

Author

Commented:
And, what is the code for the same thru Word.

Maybe I can find a way to export (or Copy/Paste) small Excel files to Word, and get some work done (from Excel to Word to PDF). And create my PDF in small reasonable pieces instead of one file.

A code will help.

Thanks.
Roy CoxGroup Finance Manager

Commented:
What sort of work do you want to export to word?
Roy CoxGroup Finance Manager

Commented:
Seems it doesn't work with Word either

Save password protected PDF file with VBA
Founder, Kenhal
Commented:
Thanks, no problem.

Atleast we know where we stand.

Thanks for your effort.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial