VBA code to save files

[superfb]

Hi guys

Is there a way to link an excel spreadsheet to a website?

Each case I work on has different dates. This tells me how many reports I need to download from a company internal website.

When I go on the company website, I select the report and use cute pdf to save this file on the hard drive I then go to the next report. Doing this manually takes a long time, would like to pick someone's brain if there's an easier method.

Bare in mind some cases gave reports from 2000 to 2019. Where for example I may just require 31/05/2009 to 07/07/2015.

I know if I press the middle button on the mouse it opens another window with the report showing, whilst the internal website remains on list of reports.

I hope my explanation makes some form of sense and somebody out there can shed some light

Thanks

 

[Rijnsent]

Hi Superfb,
"link an excel to a website" sounds cryptic, but what you basically want to do is to automate a browser from Excel. You'd have to learn some VBA, but it can save you a lot of time and boring work . Good starting points on automating browsers with VBA: http://automatetheweb.net/ and as general starting points for VBA: https://www.excel-pratique.com/en/vba.php and https://homeandlearn.org/
Hope that gets you started,
Koen

 

[superfb]

Hi

Thank you for supplying the material. Really appreciate the time taken out to send it.

I'm quite an advance user with Excel, but I have basic knowledge of VBA.

I read the link you sent.....instead of using IE can I link it to Google Chrome. And programme the VBA to go through the links one by one as each report is a hyperlink. Then print them and save it in the directory for each report.


Google Chrome

Search company name

Credit report date
Cva 06/06/2019
Csa. 05/06/ 2019
Midd. 03/03/2015


I need the reports from 01/01/2019 to 31/12/1984

saved in 20090606 and 20190605

I have macro that can assist in creating the folders.

Would appreciate your thoughts ( hope that was clearer)