Drive to Excel

[AlaminK]

How to download multiple files from Google Drive in a single workbook using Excel?

 

[Uncle Gizmo]

I don't know how to do this but I think the route I would follow is to write code in python and run that from Excel.

A script for downloading all files in a Google Drive folder.

A script for downloading all files in a Google Drive folder. - download_files_from_googledrive.py

gist.github.com

 

[ebs17]

in a single workbook

Wouldn't one load files into a folder on the hard drive?

 

[Uncle Gizmo]

The other route that might prove useful is to look at Bruce McPherson's website "desktop liberation" where Bruce demonstrates many examples of Google apps script and VBA integration.

Apps Script - Desktop liberation

ramblings.mcpher.com