Prior to my corp upgrading to Office 365 I had an Excel VBA macro that successfully would open and modify an Excel file off a SharePoint server.
Since the upgrade this file is flagged read only when opened.
I wish to be able to update the file with zero user interaction.
I've attempted various solutions offered on the web to no avail.
I've considered utilizing the API FindWindow function to drill down to the edit button and programmatically push it.
Unfortunately SharePoint seems to append the Window caption with the last modified date of the file.
Is there an easier way to address my issue.
If using the API call is the necessary course, how can I identify the window I'm seeking if the caption is changing.
THANKS for any recommendations
