web queries

Hey all, this ones got me stumped. Is there a way to keep web queries active and refreshing when saving a spreadsheet in a format viewable in a web browser? Thanks Cam

I have few excel spreadsheets with web queries in the connections, they are connecting to URL by web queries in connections. I want to refresh these spreadsheets with out open them. is there a macro to do this or any other way. Thanks

Hi all, I am looking for a little macro help. I am trying to import 10-20 pages of we information into a single excel sheet. Baseball stats for fantasy. I love it and it keeps me busy during down time. I am a beginner at code to say the least, but have a little experience. Here is what i am...

Hi there, I'm trying to use a macro to get data from an XML document where I have to use a login. The macro and workbook is intended for general users to search the document. The macro will prompt you for a value, you type it in, you will then be prompted to login with username and password...

Hi again all, I'm think I made my first post too wordy and overly complicated things..... I have a column of URLs in column A of "Sheet1". I have a web Query on "Sheet2". I want a macro to loop through all URLs in column A of "Sheet1", changing the WebQuery to use the URL as it's connection...

Hello Mr. Excel world! Long time reader first time account maker/poster. I have a workbook with a number of different Worksheets. I have a column (Column M) on a worksheet called "AM INTL" Briefing. This column contains a hyperlink on each row (none are blank right now, but there could be...

Hello, I have a web page I would like to get data from, however when I started Excel my data was gone because I had restarted Excel and the data is password protected. All the other macros I found only open Internet Explorer and go to the webpage, but I need Excel's web query to automatically...

Hi everyone! I'm pretty new to excel programming, so I apologize for any awkwardness in wording my problem. Recently I'm trying to make a database of Bank Identification Number (BIN) from binlist.net using Web Query. It basically works like this : for example I want all the information for the...

Hi! I wish to do a datestamp on some thousand web queries, with the date the query last was updated/refreshed. Is there such a value to get, or do I need to do some sort of workaround?

Hello, I would like to be able to pull the spot price of gold and silver from the internet and put them in a spreadsheet at the click of a button. I know I need to use the "Get External Data" function and / or VBA to do this. I do not know how to write Web Queries. Can someone help me out...

Hi relatively new to vba and particularly web querying. I am basically trying to download historical data from Zurich Life Fund Prices , have found it no problem to download the prices for today, but was wondering if there was a method to download prices for 13th, 12th etc etc. I'm not sure if...

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, I am strugling with writing a macro that will get the data from web. Ex website I need to get number of all properties the one in orange. You found 67,158 properties for...

I have a code that uses excel web queries to retrieve data from a web site. The query part is optimized but the rest of the code with a lot of If statements makes it run slow. Please help. Here is the code: Sub datta() Application.DisplayAlerts = False Application.Calculation =...

Hi, I have been looking through this site and the web and I have created a dynamic web query that uses a cell as a reference but I would not like to add another web query that will update at the same time and use the same cell, but i have tried a couple of things and I cant get it to work any...

As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8. The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why...

Hi, I am using excel to do a webquery on some data through web. i was doing it earlier with ease.. but recently i noticed that there is a small ad in the middle of the data i want to do web query.. so because of that the whole table which had a small arrow on the middle left corner (right next...

My spreadsheet has films and related info, laid out in standard columnar layout - one row per film, data (director, year, etc.) in columns. I would like to populate the "Blurb" column with info from an external web site, e.g. the storyline section on IMDb. Is there any way of running a query...

Hi, I am currently using VBA to import data from the web. However, I keep getting the run-time error 1004 and it occurs at this part of the code .Refresh BackgroundQuery:=False I check the url string length and it is 1147 characters... Currently using IE 8 // WinXP Is my url =...

I need help developing a excel web query in excel 2007. My objective is to use the following address http://www.google.com/base/feeds/snippets/?q=035585800011&max-results=1 and substitute the parameter q and bring back the data in columns. I would also like to list more skus in the...