Solved

Interfacing between VBA and One Drive

Posted on 2015-01-31
5
1,629 Views
Last Modified: 2016-02-10
I do a lot of VBA programming (templates, toolbars, macros) for Microsoft Office automation.  I use Office 2010 mostly as a programming platform.  

A couple of new clients (Word templates) are asking me to interact with documents and other content that will be stored on One Drive.  I've done some projects where I was talking to SharePoint, but never One Drive.

Key functions I need to be able to do include:  1) open a document that lives on One Drive into local instance of Word, 2) insert a document from One Drive into the open document in Word, 3) open a file dialog to view the files in a folder on One Drive (which I usually do Application.FileDialog(msoFileDialogFolderPicker), 4) iterate through a folder on One Drive to create a list of documents it contains (which I usually do using  Dir(folder, vbDirectory)).

I'll sure there are resources online which I can find, but does anyone have experience replicating this kind of functionality when dealing with files stored on One Drive?  

Appreciate any pointers.  Thanks in advance.
0
Comment
Question by:versatilebb
  • 2
  • 2
5 Comments
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
This isn't my area of expertise but are you sure you need to open the version on OneNote?  Wouldn't that file be sync'd to the local version so changing the local version would cause the OneNote version to be updated?
0
 
LVL 37

Accepted Solution

by:
Gerwin Jansen earned 500 total points
Comment Utility
@Pat - The question is about One Drive, not One Note ;)

About the question: I'd start at MSDN / Dev Center and looking for OneDrive development:
https://msdn.microsoft.com/library/dn659733.aspx
https://msdn.microsoft.com/en-us/library/dn641952.aspx
https://msdn.microsoft.com/en-us/library/office/dn641952.aspx
0
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
Who can type?  I meant OneDrive.  I was just reading about MS making OneNote free for everyone and so that's what I typed.
0
 
LVL 37

Expert Comment

by:Gerwin Jansen
Comment Utility
LOL ;)
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now