Need VBA Code To Get The Data From Google Drive Excel Sheet (1 Viewer)

Ashfaque

Student
Local time
Today, 15:15
Joined
Sep 6, 2004
Messages
894
Hi,

I am looking for vba code lines to import data from a Google Drive Online Recruitment (Protected Excel sheet - I have userid and pwd) to local Excel in pc or direct to Access tbl and then clean the Online Recruitment Excel Sheet (at web) so that next time when I connect web Excel again there will be new data.

Further I can manage to transfer data from local access tbl to required dept head in a specific format.

Regards,
 

Ranman256

Well-known member
Local time
Today, 05:45
Joined
Apr 9, 2015
Messages
4,336
1 method is :
to manually download the file to the same place everytime, say: c:\temp\File2Import.xls
then run queries to process data in access..

Note: the file c:\temp\File2Import.xls is linked as an external table.
This need only be done once.

(Tho someone else may have a way to read directly from the google drive.)
 

Ashfaque

Student
Local time
Today, 15:15
Joined
Sep 6, 2004
Messages
894
1 method is :
to manually download the file to the same place everytime, say: c:\temp\File2Import.xls
then run queries to process data in access..

Note: the file c:\temp\File2Import.xls is linked as an external table.
This need only be done once.

(Tho someone else may have a way to read directly from the google drive.)
Thanks Runman256,

This may helpful to me for post 50% of work but I need the code to connect Excel sheet on Google Drive and read

I need vba code or some ideas to read google drive excel file and store in local Access tbl.

Any other Idea?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:45
Joined
May 7, 2009
Messages
19,095
a further step, there is a VBA to actually write the "records" of google sheet to
a local excel file (excel vba):
you need to research the rest.

EDIT:
just test it on my google sheet and it successfully import it.
 
Last edited:

Minty

AWF VIP
Local time
Today, 09:45
Joined
Jul 26, 2013
Messages
10,346
Unless you can map the location of the target file in code, I suspect you may struggle with this.
Access doesn't understand a shared web-based folder, but it will understand a mapped drive.

There are very similar issues with Sharepoint or One-Drive file storage.
 

pekajo

Registered User.
Local time
Today, 20:45
Joined
Jul 25, 2011
Messages
132
Hi,
See
'Onedrive/Google drive Hosting'
on this forum.

on this forum
Peter
 
Last edited:

Users who are viewing this thread

Top Bottom