Thanks! "NoOp" <[email protected]> wrote in message news:[email protected]... > On 03/11/2009 11:04 PM, Raghvendra Narendra Dhoot wrote: >> The "WebQuery filter" in Calc Help, does not solve my problem, thats why >> writing on this group. > > At the bottom of the WebQuery filter information in help you will see: > > Related Topics > External data dialog > Referencing URLs > > click on the "Referencing URLs" > > <quote> > Referencing URLs > For example, if you found an Internet page containing current stock > exchange information in spreadsheet cells, you can load this page in > OpenOffice.org Calc by using the following procedure: > 1.In a OpenOffice.org Calc document, position the cursor in the cell > into which you want to insert the external data. > 2.Choose Insert - Link to External Data. The External Data dialog appears. > 3.Enter the URL of the document or Web page in the dialog. The URL must > be in the format: http://www.my-bank.com/table.html. The URL for local > or local area network files is the path seen in the File - Open dialog. > OpenOffice.org loads the Web page or file in the "background", that is, > without displaying it. In the large list box of the External Data > dialog, you can see the name of all the sheets or named ranges you can > choose from. > 4.Select one or more sheets or named ranges. You can also activate the > automatic update function every "n" minutes and click OK. > The contents will be inserted as a link in the OpenOffice.org Calc > document. > 5.Save your spreadsheet. When you open it again later, OpenOffice.org > Calc will update the linked cells following an inquiry. > 6.Under Tools - Options - OpenOffice.org Calc - General you can choose > to have the update, when opened, automatically carried out either > always, upon request or never. The update can be started manually in the > dialog under Edit - Links. > Related Topics > Inserting External Data in Table (WebQuery) > </quote>
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
