web query special

  1. E

    Web query

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

    VBA to log in to website for web query

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

    Excel 2010 web query is not working as it did in Excel 2007

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

    Not able to web query

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

    How to create a web query with special/accented characters

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top