web data import macro

Hi All, I'm working as analyst and I have been using web queries in Excel as a way to automatically get stats into my spreadsheets which are formatted for further analysis. Previously i was getting data from a different website which is no more operational. Now I have to import data through...

Hi, I would like to create a spreadsheet that I can refresh and pull in each weeks English premier League fixtures, each week I would like to refresh this and see the weeks future fixtures. I have tried to use the import function from Data/From Web and selected the box with the table of...

Hello, remembers of the forum I'm having troubles with webpage scrapping by using VBA I know I can select element of page by using - getElementByID - getElementsByClassName - getElementsByTagName However, I have no idea how to get data by Attribute For example...

I started a thread entitled "Dynamic web query". That is working well except for one issue. Some parts for a certain vendor do not display correctly. I ran macros in an attempt to determine why. Although the eventual data returned is correct, the data pasted into my spreadsheet is not...

Hi All, I want to implement a macro, that can run a SOAP statement (present in the file itself), and send the values present in the excel file to a particular system. Let me break it down for you: 1) there is an excel file with data on something...say Sales Calls made by a Sales Rep 2) there...

Hi Guys, I though I had this one solved after reading other posts but,,, I hope you can help. I have multiple cells with different currencies which are queries to this Google currency URL. https://www.google.com/finance/converter?a=1&from=SGD&to=IDR&meta=ei%3D0qLMVfnjJYGZuATQw6rgBA - changing...

I'm having a really hard time making web queries on Mac. I'm trying to import the individual words from different news articles into different columns. So, ideally, each row would have all the words from all the articles on a certain day. Whenever I use this code: WEB 1...

Hi All, I am trying to import data from a web page with a standard web address with an incremental number that identifies the web page required (weather data from a web page). However, the macro I have at the moment is not copying in the web page. I think that the issue is that the web address...

I am needing to collect data off of a website. It is all in table format already and I have experimented with Data>Get External Data>From Web. This is ideal and works perfectly. However I need to get more information from it. The URL are...

Hi , I am from Malaysia, I have an excel vba question : how to retrieve table data from web by excel VBA? Let said I want to copy a table and paste it into excel , the table is from http://www.nowgoal.com/detail/561532.html , i just want the data , similar to copy contents from web & paste it...

Hi Folks, I need some help constructing some VBA code which will do the following: Search col A of Sheet1 for the first instance of a specific text string (which starts "For Model" with potentially multiple returns, e.g. "For Model 1234", "For Model 4567", etc). Stop search at cell in col A...

Hello, I am bringing in data from the web using a macro (see below). The data from the webpage gets imported correctly, however in an internet browser, one of the columns has text with an underlying hyperlink, and I am hoping someone can help me bring that hyperlink instead of the text into...

hi , can any one please make a macro which can import all data from this site. http://www.medguideindia.com/show_brand.php i have made one & posted on this forum but no one have ever replied - please help if any one can make this. regards arvind