web query special

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...

Hello, I am attempting to build a workbook that i am going to use to get order status updates from each vendor's website. I have about 30 vendors and each one will have it's own sheet within this workbook. The problem I'm running into is getting the VBA to log in, and search a date range then...

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...

Hi all I'm trying to use the Data -> Import External Data -> New Web Query functionality in Excel 2003 SP3. If I point the query at a standard web page, such as: http://www.someDomain.com/someXML.xml?A=someData&B=moreData I get the table back no issues with all available data elements...