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]
