Ask Your Question

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

asked 2018-01-24 11:16:49 +0100

Mo06 gravatar image

updated 2018-01-24 12:51:04 +0100

floris v gravatar image

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

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

Next i
edit retag flag offensive close merge delete



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.

Ratslinger gravatar imageRatslinger ( 2018-02-22 04:49:00 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-02-21 11:38:04 +0100

Mo06 gravatar image

Is there really nobody who has done this ?

edit flag offensive delete link more


Please don't answer yourself.

m.a.riosv gravatar imagem.a.riosv ( 2018-02-21 17:39:09 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-24 11:16:49 +0100

Seen: 140 times

Last updated: Feb 21 '18