Hello - I have a program that I developed in Excel that I'm trying to make compatible in Open Office versions. The problem that I'm stuck on right now is that the macro to pull in data from the web is crashing. I tried to record a macro in OO to get the correct syntax for OO, but the record tool doesnt seem to actually record that code. This, given a url, inserts a link at the current cell: Code: Sub InsertWebLinkAtSelection(url As String) Dim oDoc As Object Dim oSelection Dim oAddress As new com.sun.star. Magmasoft V4 4 Sp34withexceed_2011 on this page. table.CellAddress oDoc = ThisComponent oSelection = oDoc.getCurrentController().getSelection() if oSelection.supportsService('com.sun.star.sheet.SheetCell') then oAddress = oSelection.getCellAddress() oDoc.AreaLinks.insertAtPosition(oAddress,url,'HTML_all','calc_HTML_WebQuery','0 0') endif End Sub Note the 'HTML_all,' which just gets everything. With Link to External Data one normally gets a selection of HTML ranges, and it is possible to obtain these in advance, so that one could perhaps present them in a dialog, but I'll leave that part aside for the time being.

Just do something like Code: Sub Main Dim url As String url = whatever routine gets the url InsertWebLinkAtSelection(url) End Sub. Downloading Xbox 360 Games Iso. Apache Cxf Rest Example.

Bn-InLibre Calc Web Query

Printing Queries. To print a query or table: Open a text document (or a spreadsheet document if you prefer the specific printing functions of this type of document). Libre Office V 3.6.2.2 Running on Windows. Specify Web Page Query (Calc). [Solved] [Calc] Inserting Data from Web. Linking to external data. You can insert tables from HTML documents. Go to the source document, which you opened in Calc using the Web Page Query filter.