Hello Stephan,
unfortunately, I have to bother you again. I tried all imaginable
possiblities to get the result.
I went through all options om thje menue "extras" of OO1.1.4. Everytime I
get the following
replay in the cell:
the link could not be updated
This message I get up to eight-times; the messages appear in the first row,
beginning at (0,0).
Within the spreadsheet, I can click at the position (0,0) for the contents
of the web-site of
finance.yahoo (as stated below) and I get the desired result, Thus it cannot
be problem
of the settings of the IE. It must be one of the parameters of OO, which I
probably did
not set correctly. Maybe you can send me a web-page which explains this
problem. I
looked at google and yahoo with no result.
Thank you very much in advance.
Rudi
----- Original Message -----
From: "Stephan Wunderlich" <[EMAIL PROTECTED]>
Newsgroups: openoffice.api.dev
To: <[email protected]>
Sent: Monday, February 20, 2006 10:27 AM
Subject: Re: [api-dev] Unanswered Request - Fw: [api-dev] HTML and
Spreadsheet - BASIC
> Hi Rudolf,
>
> > thank you for your prompt message.
>
> you are most welcome :-)
>
> > I tried VISIBLE = TRUE also. It shows the the link "LINK", but I do not
see
> > the contents. The problem seems to be to get
> > the contents into a defined cell. Apparently, I have to enlarge the
size of
> > the cell. Is there a method to transfer the contents of the web-page of
the
> > cess from my spreadsheet table to CSV-format file. Once I can achieve
> > this I can solve the problem.
>
> The following macro should get the webpage into calc
>
> sName="SUNW"
> oSheet = ThisComponent.Sheets(0)
> sUrl = "http://finance.yahoo.com/q?s="; + sName
> AreaLinks = ThisComponent.Arealinks
> xCell = oSheet.getCellByPosition(0,0).CellAddress
> Arealinks.insertAtPosition(xCell, sUrl, "html_all",
> "calc_HTML_WebQuery", "" )
>
> You could choose an additional invisible sheet as in your sample to
> place the data there, then link the essential part of this data to lets
> say your first sheet and save the document using XStorable.storeToURL,
> thereby using the csv-filter.
>
> Hope that helps
>
> Regards
>
> Stephan
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
