Open web page with VBA

I'm not sure how to prevent the file save prompt from coming up, perhaps someone else can help with that, but as far as just opening the page:

Please Login or Register  to view this content.

I know chrome can be somewhat controlled via VBA (or at least used to) but it is not as easy as Internet Explorer. I've never actually done it, sorry.

Didn't need to mark as solved, I'm sure someone else would be able to help further, this is just not an area I'm very versed in. I do know that for Chrome you'd need to download and install something (Selenium-VBA) to be able to automate chrome.

Sorry I wasn't more helpful, but thanks for the rep

To download file something like below.

Change fPath to suite your need.

Please Login or Register  to view this content.

Alternately you can use Get & Transform to directly query data without download.

Ex: Create blank query, then go into query editor. View -> Advanced Editor. And paste below.

Please Login or Register  to view this content.

Nice CK Thanks for jumping in! I'd put it in the cavalry thread since I was afraid with responses already, it could get missed.

No problem

This is pretty frequent request. I just had to change few things around on my standard code library.

This may be another alternative to dump the data from the CSV file located on the server, into the active sheet;

Please Login or Register  to view this content.

Try this;

Copy and paste the following into a module and run the macro "Main"

This macro will get the data related with the last Wednesday before today. For other weekdays; use vbMonday, vbTuesday,.....vbFriday

Please Login or Register  to view this content.

And, if you want the macro to get the weekday from a cell, say E2 then use the macro "Main" as this;

Note: Cell E2 will contain the weekdays Monday, Tuesday, Wednesday, Thursday or Friday.

Please Login or Register  to view this content.