Andrew Douglas Pitonyak <andrew <at> pitonyak.org> writes: >
> > I have struggled for two weeks with this exact problem! Why can't openoffice > > handle the URL > > "http://quote.yahoo.com/d/quotes.csv?s=MSFT&f=sl1d1t1c1ohgv&e=.csv";, when > > Firefox handles it perfectly. Obviously earlier openoffice did handle it but now > > cannot. See the thread at http://www.oooforum.org/forum/viewtopic.phtml?t=4103. > > > Well, this works! It gets the stock prices for Qwest (Q) and HP and > stores it in a calc document. > > Sub two_stock_prices() > Dim sUrl As String > Dim oDoc as Object > Dim oPropertyValue(0) As New com.sun.star.beans.PropertyValue > > sUrl = "http://finance.yahoo.com/d/quotes.csv"; & _ > "?s="& Join (Array("Q", "HP"),"&s=") & _ > "&f=sl1d1&e=.csv" > > oPropertyValue(0).Name = "FilterOptions" > oPropertyValue(0).Value = "44" > oDoc = StarDesktop.loadComponentFromURL( sUrl, "_blank", 0, > oPropertyValue) > End Sub > Andrew, you have convinced me that I have to buy your book on openoffice macros! If I can fit that code (I'm a 74 year old amateur) into the larger macro I should have what I want. Thankyou! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
