Instalation

Here are basic instructions on how to setup DrivEPM

1. OAUTH2 Authorization
2. Create Google Drive Sheet
3. Create DrivEPM config file
4. Setup VBA references, modules and classes
5. OAUTH2 Final Setup

# OAUTH2 Authorization

1. Go to Google Developer Console to create an Cloud Project

   

2. Enable Sheets API

   

3. Create a OAUTH client ID

   

   • Choose a name for this ID

   

   • Copy the client ID and client secret bellow

   

   In my case this was :

   ClientID = 630494151739-kfrm8clt01h0jchbs6ld23t07etreiaj.apps.googleusercontent.com
   ClientSecret = JDZmX5WYEuGCuZ0APvT5X6QA

# Create Google Drive Sheet

1. Create an drive sheet and write down the created sheet ID

   

   

   In my case this was :

   SheetID = 16NkAiBXX-x6UTBBtiwsA8i8caUz3crak6eSBpgALmWE

# Create DrivEPM config file

1. Create a configuration file named "drivEPM.config" and put it on the same folder of your project ".mpp" file with these contents:

   "SheetID","16NkAiBXX-x6UTBBtiwsA8i8caUz3crak6eSBpgALmWE"
   "ClientID","630494151739-kfrm8clt01h0jchbs6ld23t07etreiaj.apps.googleusercontent.com"
   "ClientSecret","JDZmX5WYEuGCuZ0APvT5X6QA"

   These information above are just an example, you must use your own data.

# Setup VBA references, modules and classes

1. Open project file with macros enabled and at VBA for application references add these:

   • Microsoft Internet Controls and
   • Microsoft XML

2. Add classes:

   • cBrowser,
   • cJobject,
   • cOauth2,
   • cProject,
   • cSheetsV4 and
   • cStringChunker

3. Add modules:

   • functions and
   • drivEPM

# OAUTH2 Final Setup

9. Before first use you must execute VBA macro "RunOnce()"

   

   This VBA code will save OAUTH Authorization token into windows registry, so after first run and for security reasons you may remove these OAUTH ID and secret lines from "drivEPM.config".

   "drivEPM.config" will just look like this:

   "SheetID","16NkAiBXX-x6UTBBtiwsA8i8caUz3crak6eSBpgALmWE"