Hi I have an excel workbook with a query linked to a Google sheets... I want to replicate this in libreoffice calc.

[Mo06]

This is the VBA code I use in excel:

Workbooks(strX).Sheets(“RAW DATA”).Activate

X = ActiveSheet.QueryTables.Count
Debug.Print X

For i = 1 To X

    ActiveSheet.QueryTables(i).Refresh
    Debug.Print ActiveSheet.QueryTables(i).Name
    Debug.Print ActiveSheet.QueryTables(i).Connection

Next i

[Ratslinger]

Hello,

You shouldn’t ask people to interpret MS VB code here. Instead actually ask how to get wanted result.

Have you checked out Is Google Docs import supported?(note esp. comments) and related Connect LibreOffice with your Google Docs account by using OOo2gd.

[Mo06]

Is there really nobody who has done this ?

[mariosv]

Please don’t answer yourself.