Uploading to Google Drive using VBA or VB

I'm not aware of a way to upload to Google Drive w/o additional software. See this link for several applications that either can setup Google Drive as a mapped drive or a local folder. Using any of the suggested applications all you need in vba is to copy your file to the local folder and from there it gets uploaded automatically.

Why not post the C# example here? It shouldn't be too difficult to convert.

GrahamSkan,

Here is the C# code provided by Google for uploading documents to Drive.  

This came from:  https://developers.google.com/drive/quickstart-cs

Any help you or anyone else can provide in converting this to vba would be very much appreciated.

using System;
using System.Diagnostics;
using DotNetOpenAuth.OAuth2;
using Google.Apis.Authentication.OAuth2;
using Google.Apis.Authentication.OAuth2.DotNetOpenAuth;
using Google.Apis.Drive.v2;
using Google.Apis.Drive.v2.Data;
using Google.Apis.Util;
using Google.Apis.Services;

namespace GoogleDriveSamples
{
    Class DriveCommandLineSample
    {
        static void Main(string[] args)
        {
            String CLIENT_ID = "YOUR_CLIENT_ID";
            String CLIENT_SECRET = "YOUR_CLIENT_SECRET";

            // Register the authenticator and create the service
            var provider = new NativeApplicationClient(GoogleAuthenticationServer.Description, CLIENT_ID, CLIENT_SECRET);
            var auth = new OAuth2Authenticator<NativeApplicationClient>(provider, GetAuthorization);
            var service = new DriveService(new BaseClientService.Initializer()
            {
                Authenticator = auth
            });

            File body = new File();
            body.Title = "My document";
            body.Description = "A test document";
            body.MimeType = "text/plain";

            byte[] byteArray = System.IO.File.ReadAllBytes("document.txt");
            System.IO.MemoryStream stream = new System.IO.MemoryStream(byteArray);

            FilesResource.InsertMediaUpload request = service.Files.Insert(body, stream, "text/plain");
            request.Upload();

            File file = request.ResponseBody;
            Console.WriteLine("File id: " + file.Id);
            Console.WriteLine("Press Enter to end this process.");
            Console.ReadLine();
        }

        private static IAuthorizationState GetAuthorization(NativeApplicationClient arg)
        {
            // Get the auth URL:
            IAuthorizationState state = new AuthorizationState(new[] { DriveService.Scopes.Drive.GetStringValue() });
            state.Callback = new Uri(NativeApplicationClient.OutOfBandCallbackUrl);
            Uri authUri = arg.RequestUserAuthorization(state);

            // Request authorization from the user (by opening a browser window):
            Process.Start(authUri.ToString());
            Console.Write("  Authorization Code: ");
            string authCode = Console.ReadLine();
            Console.WriteLine();

            // Retrieve the access token by using the authorization code:
            return arg.ProcessUserAuthorization(authCode, state);
        }
    }
}

Thanks MacroShadow, but much of this isn't compiling in vba.  I was able to fix some of it, but many lines I'm not sure how to translate.

It's not VBA it's VB.Net.

Sorry MacroShadow,

I'm not as familiar with VB.net as VBA, and will attempt to convert this code to VBA.  

Thanks for your help with this.

Impossible.

I'm going to give the Internet Explorer library solution a try.