To print PDF generated from an URL. Where URL is listed in Column A and name is stored in Column B and saved directory should be in D folder!

T

tcimran

New Member
Joined
Dec 14, 2021
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Hy Excel Experts,

Is it possible to automate print and save using macros, like I have a list of URLs in Column A and a list of its file name to be saved in Column B, I want to go to each URL and save the pdf in it to a specific directory.
Hope it's possible because there are 100+ pdfs every month. ;)

Thanks
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
You must log in or register to reply here.

Similar threads

C
  • Question
Extracting Specific Fields from multiple PDFs with VBA (Excel 2019)
Replies
1
Views
168
chickyguy
C
G
  • Question
Macro to consolidate multiple worksheets into Master based on cell data?
Replies
1
Views
246
bobaol
B
C
  • Solved
VBA Print to PDF Macro (with specific file name and type)
Replies
2
Views
250
CHOPDOG
C
S
  • Solved
For each row, create new folder based on single cell value, then save exported XML doc to matching folder.
Replies
3
Views
129
shand
S
J
  • Question
VBA to save all indicated in range tabs as all separated PDFs with name of the tabs in the same place where the excel file is
Replies
5
Views
525
Jorgi
J

Forum statistics

Threads
1,214,416
Messages
6,119,384
Members
448,889
Latest member
TS_711

Share this page

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