VBA and writing to Sharepoint files
Is it possible to write to an Excel file that is online (Sharepoint) using VBA?
I have a bunch of Excel “applications” from which I would like to push data onto a shared Excel file so my colleagues and I can use the desktop version of the “applications” on our own machines, and have the data we generate pushed up to a shared file that can be viewed by everyone (non-users, ie management) who can then create their own reports and such from.
Is it possible to write to an Excel file that is online (Sharepoint) using VBA? I have a bunch of Excel “applications” from which I would like to push data onto a shared Excel file so my colleagues and I can use the desktop version of the “applications” on our own machines, and have the data we generate pushed up to a shared file that can be viewed by everyone (non-users, ie management) who can then create their own reports and such from. Read More