Excel VBA code to sync Local excel sheet and another excel sheet saved on google drive

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

Hi,

I have 2 excel sheets, which are a copy of each other. One is saved on my local drive (My Laptop), and the other is saved on my google drive. In the sheet saved on the google drive, a colleague can go ahead and change values in certain cells. Currently I have to download the sheet from google drive, look at the changed values and then update my excel sheet (the local excel sheet, on my Laptop). What I want is a VBA code, which I can run on my Local excel, which will fetch values from 3 cells on 3 different tabs on my google drive excel, and then plug those values in my local excel.

Its a quick code for anyone who knows how to connect the two

Please note: I do not have google drive app on my PC and don't intend to install it as well

Excel Visual Basic Visual Basic pro aplikace

Identifikační číslo projektu: #17522825

O projektu

3 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

archanaoswal

I know how to extract data from Google Sheets into Excel using VBA. (without installing Google Drive) I have excellent command on MS Excel and Google Sheets. I have completed complex projects in Excel before . F Další

₹1500 INR za 1 den
(53 recenzí)
5.5

3 Freelnceři na tento projekt zveřejňují nabídky v průměru ₹1417

REDFEATHERART

HI, I have done similar task. I can do it easily within the time frame. I have been doing these types of task fro 9 years. I AM AN EXPERT AT EXCEL.

₹1500 INR za 0 dní
(4 Recenzí)
2.5
GeorgeVBA

Hi there, I have been working with Excel since the 97 - 2003 version. I specialise in linking Excel with external apps. I would be happy to work on this for you. look forward to hearing from you. Regards George

₹1250 INR za 3 dní
(0 Recenzí)
0.0