Oddly enough I'm having a problem with Excel for once!
I'm trying to perform a Web Query for the current day interest rates at U.S. Bank.
No matter what I've tried I still get 'The web query returned no data...' I've tried on Excel 2007 with IE7, Excel 2003 with IE7 and Excel 2007 with IE6.
1. Can anyone else get this query to work?
2. If not, are there any alternatives?
I've even tried reading from the locally cached version of the web page with no luck. Is there possibly a way to grab the source code from a page, after which I could parse it using VBA?
Update: I found this thread - How To Save HTML Source Code, and it works for that, but I'd prefer to find out if I can use web query or an alternative rather than start parsing the text file this macro creates.
The page itself is a .cfm file, but of course behind the scenes it's really just HTML with some Cold Fusion built in.
Thanks for any ideas..
Bookmarks