Using Calc I have an inventory of precious metals. There is a website that has a running chart of spot prices. There is a box on this site that shows the current price. I would like the contents of that box placed into a cell at the activation of that cell.
At present I hyperlink to the site, copy the box and then paste the info into the cell.
It seems like I could do it with a macro but am not familiar with them.
I think I just answered my question. I'll keep looking.
Thanks for your help
Value from a web page placed into a cell
Value from a web page placed into a cell
Open Office 4.1.14 - Windows 11, 64
Re: Value from a web page placed into a cell
Depending on how the web page is structured, you might be able to use Linking to external data. There is also information in the offline HELP - search external data.
Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.8.3.2; SlackBuild for 24.8.3 by Eric Hameleers
---------------------
Apache OpenOffice 4.1.15
LibreOffice 24.8.3.2; SlackBuild for 24.8.3 by Eric Hameleers
---------------------
Roses are Red, Violets are Blue
Unexpected '{' on line 32
.Re: Value from a web page placed into a cell
Users of LibreOffice V 4.2 or higher may also try WEBSERVICE() combined with FILTERXML().
Please note:
I'm not an expert in pulling details from the web, and used the mentioned functions myself only once for a solution years ago.
Please note:
I'm not an expert in pulling details from the web, and used the mentioned functions myself only once for a solution years ago.
On Windows 10: LibreOffice 24.8.3 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: Value from a web page placed into a cell
I haven't found a web page that will allow me to use the only number I'm after so I'm still searching. I did find one that allows me to use a range of data with the number I'm after but I can't figure out how to access that particular number. I did set up a link to the site so that I can copy the number and place it for now. I'll figure it out and thanks for your help.
Open Office 4.1.14 - Windows 11, 64