Bryce Bassett
asked on
Interfacing between VBA and One Drive
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(mso FileDialog FolderPick er), 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.
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(mso
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.
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Who can type? I meant OneDrive. I was just reading about MS making OneNote free for everyone and so that's what I typed.
LOL ;)