Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OS: Windows NT 4, SP6A
Excel: 10.2614.2625 (Office XP) IE: 6.0.2800.1106 Hi all, I'm dealing with the following problem: www.CBOE.com has changed his website structure and I dicovered 2 changes. 1. The URL has changed, 2. The filename (to download) has changed. * My old web query: WEB 1 http://quoteservice.cboe.com/QuoteTable.dat * My new web query: WEB 1 http://www.cboe.com/delayedQuote/QuoteData.dat * MY PROBLEM: Right now I'm unable to retreive a QuoteData.dat file via Excel web query with a required symbol (PostText value in VBA) * The new page to enter the request manually (web form) is http://www.cboe.com/delayedQuote/Quo...eDownload.aspx * Here is my code: Sub ini_quotes() 'Initialize Quotes Dim DR As Object 'Data Range Dim PTV As String 'PostText Value PTV = "Ticker=" & Range("QS") 'Example Ticker=MSFT With ActiveSheet.QueryTables.Add(Connection:= _ "FINDER;C:\Temp\SSSKAT22\Filter.iqy", Destination:=Range("A1")) .Name = "DR" .PostText = PTV .Refresh BackgroundQuery:=False '<<-- UNABLE TO RETREIVE THE QUOTEDATA.DAT FILE! End With End Sub Unfortunately CBOE.com refused to help me: "I apologize but we cannot assist you with that because we do not allow the query you are attempting to perform because of the load it can place on our servers, and because of other additional security concerns. I apologize for the inconvenience." Has someone have an idea/suggestion how to solve this issue? Thanks in advance for any comments! Kind regards, - Bas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
chart line style problem | Charts and Charting in Excel | |||
How do you post a query in excel? | Excel Worksheet Functions | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions | |||
Re-post of existing problem | Excel Programming | |||
Problems with Excel Web Query for Post Method URL | Excel Programming |