Interfacing between VBA and One Drive
Posted on 2015-01-31
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.