VBA to Link MS Excel to Google Sheets

[rmnewjers]

Hello...I am trying to determine whether or not there exists a VBA to link data from Sheet2 of an MS Excel workbook to Sheet1 of a Google Sheets workbook in order to avoid an indulgence of copying and pasting.

Robert

 

[Inacio11]

Hello,
Maybe websites integration such as Zapier, IFTTT, Microsoft Flow could support you......They have available functions to execute this tasks. Regards

 

[offthelip]

You don't need to use VBa you can do that with a excel webQuery,
Select Data > Get External Data > From Web, and the paste the url of the google sheet you want to link to your EXCEL sheet and then import the data.