Download PDF Links

J

jackcel

New Member
Joined
Jul 16, 2014
Messages
5
Hi everyone,

I want to automate the process of downloading PDF reports as and when they come up. These reports are industry reports that are released quarterly. Please see url: JTC Corporation

The reports links are 4Q 2013, 1Q 2014 and the latest 2Q 2014 (righ side of the webpage).

Just wonder if there can be a macro to download the 3Q 2014 report when it comes up and archive all the reports within an excel sheet? If not a designated folder might be just as good. Appreciate your help!

Thanks
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
You must log in or register to reply here.

Similar threads

G
  • Question
Fuzzy Match code
Replies
1
Views
2K
gelu
G
M
  • Question
Different results running same macro with same data
Replies
3
Views
2K
Logit
Logit
N
  • Question
Send Out Macro not workig with PDF
Replies
7
Views
343
Ruddles
Ruddles
M
  • Question
Rolling Forward Lookup formulas (financials reporting)
Replies
0
Views
454
mark9988
M
J
  • Question
Trying to report differences between two .pdf files using Excel
Replies
1
Views
677
daverunt
D

Forum statistics

Threads
1,214,605
Messages
6,120,476
Members
448,967
Latest member
visheshkotha

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