Click here to Skip to main content
15,112,662 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I got an Excel sheet on Google Docs which contains details of people.
Every time a person sends me an excel sheet with his details over email, I manually update it into the Excel sheet on Google Docs where all the persons' details are.

I'd like to automate that process, that once someone sends me an excel sheet with his details, I'll have a macro / script that updates the Excel Sheet on Google Docs.

Is it possible to have a macro / script that imports data from Local computer to Google Docs?

Thank you.

What I have tried:

I am experienced with VBA, but not with updating Excel Sheet on Google doc from an Excel sheet on a local computer.
Updated 27-Sep-17 4:11am
Richard MacCutchan 27-Sep-17 9:18am
I guess the issue is where your workbook with the macro is loaded from (Google docs or local), and whether it has clear access to the workbooks on the alternate location. Should be easy enough to construct a simple test.
Member 13408460 27-Sep-17 14:40pm
Hi Richard.
Thanks a lot for the inputs.
Could you please elaborate?
I have a clear access to Google Docs from my laptop.
I can place the Macro either local or on Google Docs, I just don't know where I should put.
How would you suggest to do it? I mean in guide-lines (not Code concerning of course).
Thank you.
Richard MacCutchan 27-Sep-17 15:54pm
Sorry, I cannot suggest anything else as I do not use Google docs. As I said above you need to try some simple tests just to check that you macro can access both workbooks.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900