Copy specific range from Google Sheets & Paste the values to excel

1
votes

This is my first post & hello to everyone

I'm using Excel 2003 & Not a programmer - Can do some basic VBA coding.

GOAL: (Reproduce the effect of Ctrl+C from Google Sheets & Paste special - Text to Excel)

Use VBA to Copy the range "C2:E5" of a google sheet & paste it's values to range "O31:Q34" in Excel document. Using a button in Excel would be nice.

I've tried to follow several similar posts and leads: Script to copy range/cells value from Google Spreadsheet - paste in Excel

Copy data from Google Sheet to Excel

And while some were promising, it were too advance for my knowledge. Is there any simple way to reproduce that copy/paste? Thank you in advance.-

EDIT: The excel file and the google sheet are kept open at all times. The values of the google sheet change every 15 seconds or so and I manually use copy/paste to transfer them.

1
excelvbagoogle-sheets

1 Answers

1
votes

First: Share your spreadsheet from google with editor mode, ie: https://docs.google.com/spreadsheets/d/19285912859128591859-LIFFM/edit?usp=sharing

Second: Edit the URL like this with "export?format and xlsx": https://docs.google.com/spreadsheets/d/19285912859128591859-LIFFM/export?format=xlsx

Finally click in "Get Data From Web" in Excel and past that URL above. That it's all you need. If you need more info, just ask.