?
Solved

Interfacing between VBA and One Drive

Posted on 2015-01-31
5
Medium Priority
?
2,805 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:Bryce Bassett
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 38

Expert Comment

by:PatHartman
ID: 40609911
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 38

Accepted Solution

by:
Gerwin Jansen, EE MVE earned 1500 total points
ID: 40609923
@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 38

Expert Comment

by:PatHartman
ID: 40610052
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 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40610077
LOL ;)
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Microsoft Office 365 is a subscriptions based service which includes services like Exchange Online and Skype for business Online. These services integrate with Microsoft's online version of Active Directory called Azure Active Directory.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

752 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