download data internet

Hello everyone, I am trying to download a bunch of tables from a site (allowed by the site administrator). I can use the site's filters/search tools and get all my data by year on a web page. However I need 20 or so years worth of data, so I have to click on each year one by one to access the...

Dear all, I'm trying to use VBA to download the odds for Manchester United versus Manchester City. I would like the odds to come from unibet.com which is using flash (i think). Is that possible? If not, is there a way around it? I will really appreciate your help. Kind regrads Rasmus

I am very new to the macros.I want to know can we develop a macro to download report from online website.based on the names which i can select form drop-down list,i want to download same reports for each name.can i do this using macros. Please help me to do this.

Greetings, I've been reading this forum for a couple years now, but this is my first time posting a question. As they say on the radio call-in shows, "First-time, Long-time." While I've grown leaps and bounds in my general excel macro writing, I am just beginning to delve into automating...

Hello Experts, I have below code to download some files from given URLs using VBA. Is there a way using which I can use this function in VB Script? Currently it is not allowing me to use these functions as is: Private Declare Function URLDownloadToFileA Lib "urlmon" (ByVal pCaller As Long, _...

This is something of a conceptual question rather than on the specifics of code (ie am I going about this the right way in general or is there a better technique I could use?). I think that my problem represents a broad issue affecting many of the inexperienced people who post on this forum so...

Hello , i have a web url on which if we click a file gets downloaded, i have written a macro to download the files from list of URL's but i am not able to extract the actual filename of it. Ex: https://www.somename.com/sonename/clients/HHHSSS/documents/T134/play If we click on this link a...

Hi, This is quite tricky. I have been asked to download data from the internet using a macro. Unfortunately it is not simple atleast for me. Here is the task I have been given. 1. Go to http://www.bloomberg.com/markets/companies/ 2. Click Chemicals and go to Agricultural Chemicals...