web queries

I am just (re)learning VBA having purchased Mr. Excel's book about macros and VBA programming. I am specifically interested in the ability to import web data into a spreadsheet. In experimenting on a very limited basis, I have noted two issues: (1) on some web sites excel is inconsistent in its...

Is there a way to delete all web queries within a worksheet/workbook using VBA? Thanks

Hello, I need help with some code. What I have is an extremely simple worksheet. Column A has Stock Tickers, my Code Goes out and grabs the Prices for the Tickers, and I want to put the Price for the Stock in the adjoining Column B of the Worksheet. However, right now the values return fine...

Hey all. I wrote a macro that goes to the internet and into my Yahoo! Finance imports the entire page, searches for the word portfolio value, goes down one cell to grab that value, brings it back to a data worksheet and deletes the imported data. I am trying to set it up so this program runs...

Hi all, I've set up a web query in VBA, which works fine, but I'd like to know if and how I can access the data within the query directly from VBA. I think it uses a recordset but can't seem to get to it, I'm not too skilled at the topic. Point is that I retrieve all tables from a web page...

Hi, I wanted to know if this is possible. I have a scenario where I have reports generated on a website from a different department. The issue is that because they're daily updates, the link for the most up to date information changes daily to that days date, for example, For the reports...