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


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

Compétences : Excel, Visual Basic, Visual Basic pour les apps

en voir plus : update google spreadsheet from excel, auto update google spreadsheet from excel, syncing excel data to google sheets, how to sync excel files with google drive, google spreadsheet and excel work in real time together, import data from google sheets to excel, how can i link google sheets to excel in real time, link excel sheet to google sheets, excel vba code optmization, excel vba code optimis, excel vba code log websites, excel vba code ftp, excel vba code update, excel vba code open internet explorer, inventory excel vba code, optimizing excel vba code, optimize excel vba code, excel vba code check add ins, excel vba code data web page, create domain class excel vba code

Concernant l'employeur :
( 4 commentaires ) Mumbai, India

Nº du projet : #17522825

Décerné à:


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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% INR en 1 jour
(53 Commentaires)

3 freelance font une offre moyenne de ₹1417 pour ce travail


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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 0 jours
(4 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(0 Commentaires)