Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IQY File: Invalid Web Query
I'm using an iqy file to import websites to excel. The text within the iqy
file is as follows: WEB 1 http://finance.yahoo.com/q/hp?s=["Company"] The ["Company"] parameter is linked to a specific cell, which is my variable (stock ticker symbols). I created a macro to to refresh the work book, the VBA code reads as follows: Sub Macro1() ActiveWorkbook.RefreshAll End Sub I entered EBAY into the ["Company"] parameter cell and ran my macro, then an error messaged appeared. "The file could not be accessed. Try one of the following: -make sure the specified folder exists -make sure the folder that contains the file is not read-only -make sure the file name does not contain any of the following characters: -make sure the file/path name doesn't contain more than 218 characters. When I close out of that error another error appears. "Invalid Web Query" The entire process works for some ticker symbols but not others; even when the website truly exists. Please help! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invalid web query Excel 2007 | Excel Discussion (Misc queries) | |||
Invalid Web Query Error | Excel Programming | |||
Invalid Web Query errors. | Excel Programming | |||
why dose excel return invalid web query | Excel Discussion (Misc queries) | |||
Locating Invalid Web Query Data | Excel Programming |