search

brucemcpherson / desktopliberation

hosting for desktop liberation google plus community
30 stars 1 forks source link

Copying a selected range from Excel into a certain location in a Google Sheet #15

Open jasonsipes opened 5 years ago

jasonsipes commented 5 years ago

Hello. I am new to forums so my apologies if I'm not doing this correctly. I'm also new to VBA, though I have a good background in C and C++. I have been teaching myself VBA for about a year now.

I'm trying to perform what I hope is a relatively simple task. I would like to be able to select a range in an Excel Sheet and run a macro to copy that range into a particular range on a particular sheet in a specified Google Sheet.

I've gone through the "Using the Google Sheets V4 API from VBA to integrate Sheets and Excel" and have successfully been able to create a test sheet and have the macro run to copy the entire sheet from Excel into Google Sheets.

I'm very new to jSon, cOauth2, cJobject, serialization, etc.

How should I modify the code provided in "Using the Google Sheets V4 API from VBA to integrate Sheets and Excel" to be able to take the selected range and place it in a particular location of an already existing Google Sheet?

Thank you for your help!

brucemcpherson commented 5 years ago

Hi Jason - can you post the snippet of code that you already have for selecting the data. you can send to me directly at bruce@mcpher.com if you dont want to post here.