Ask Your Question
0

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 +0200

Mo06 gravatar image

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

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

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

Next i
edit retag flag offensive close merge delete

Comments

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.

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

1 Answer

Sort by » oldest newest most voted
0

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

Mo06 gravatar image

Is there really nobody who has done this ?

edit flag offensive delete link more

Comments

Please don't answer yourself.

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

Question Tools

1 follower

Stats

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

Seen: 97 times

Last updated: Feb 21 '18