Open PDF and Print to PDF using VBA

yash_dalmia

New Member
Joined
Sep 7, 2018
Messages
2
Hi All,

I am in need of a VBA code to open PDF files from different locations and then print to pdf and save in another location.

Further explanation:
- I would like to open all the pdf files in A:\BuyerDownloads\
- I would then like the opened files to be printed to PDF and saved in A:\Vinayaka\Operations_VFPL\Contracts
- The path A:\BuyerDownloads\ is constant but the number of folders inside vary on a week to week basis. There are also instances of multiple folders inside one another in the path A:\BuyerDownloads\

Any help on the above is appreciated, thank you.

P.S. I am a complete newbie to VBA
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
If its already a PDF, you don't need to print it.
just copy it:

filecopy source, target
 
Upvote 0
If its already a PDF, you don't need to print it.
just copy it:

filecopy source, target

I need to print to pdf again because each pdf in path A:\BuyerDownloads\ verifies signatures each time the file is opened. But once the files are printed to pdf the signatures are not verified again and it is printed is signature verified.
 
Upvote 0

Forum statistics

Threads
1,223,896
Messages
6,175,260
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top