Solved

Interfacing between VBA and One Drive

Posted on 2015-01-31
5
1,947 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 35

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 37

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 35

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 37

Expert Comment

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

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Cloud-based technologies and services will continue to grow in popularity in 2017 thanks to the simple, scalable and cost-effective solutions they deliver. Here are three areas where cloud adoption is poised to really take off.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

773 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