Hi Stephan, the message which I get always is
the link could not be updated
I tried various settings, including all security settings under
EXTRAS-options and options under IE Version 6. I looked at the
setup-procedures regarding security. I run this macro under WindowsME and
Version OO1.1.4. I tried your macro and I tried various options with
arealinks and sheetlink. No luck. Thank you for your help in advance.
Using the hyperlink function in a cell - without a macro - I have no
problem.
Regards,
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]
>
TestWunderlich.sxc
Description: OpenOffice Calc spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
