Macro that downloads an excel file in a folder in google drive

[Macub_X]

Hi guys,

May I ask anyone of you knows any VBA code that can download an excel file in google drive. I am coding an excel program that refreshes its data whenever there is a new data dump present in a folder in my google drive.

Thanks a ton!

 

[AlphaFrog]

Google Drive puts a local copy of files on your computer.
Google Drive folder
The default local path is usually in the user's Documents and Settings folder

The code below opens an Excel file from the Google drive local folder.
Change the User, SubFolder, and File Name to suit.

    Workbooks.Open "C:\Documents and Settings\[COLOR="#FF0000"]User[/COLOR]\My Documents\Google Drive\[COLOR="#FF0000"]MyFolder[/COLOR]\[COLOR="#FF0000"]MyFile.xlsx[/COLOR]"

 

[Macub_X]

Unfortunately, company restrictions won't allow me to install applications in my company issued laptop. I figured out I just have to directly download data from google drive.

 

[jaryszek]

hi i am looking for solution for this.
Did you solve the problem ?

Jacek