Solved

Interfacing between VBA and One Drive

Posted on 2015-01-31
5
2,366 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
[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 37

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 500 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 37

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Microsoft Office Picture Manager has a Picture Shortcuts pane that shows a list with the Recently Browsed folders. While creating my video Micro Tutorial here at Experts Exchange showing How to Install Microsoft Office Picture Manager in Office 2013…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

732 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