Kill AutoSave on Sharepoint Files

Our IT department just moved a slew of source files I access every day onto a SharePoint site. So far it's clunky, I don't like it, but I don't get a voice in that decision. With that said, I need help in modifying some of my macro tools.

The macro below I've been using to turn off the Autosave options when these source files are opened. The old path is at the top of the macro, the new path is below. As configured, I get no error from the macro, but neither is it working on the SharePoint files I open. I've tried leaning my divider lines both ways, and that doesn't seem to help. I'd appreciate whatever advice I can get on this.

Related, I used to have hyperlinks to each file I needed, but with SharePoint the file path seems to change on my hyperlinks, so yesterday's hyperlinks don't work today. if anyone has a workaround for that I'd appreciate hearing it.

Please Login or Register  to view this content.

I'm thinking part of the problem might be the workbook path. SharePoint adds other details to the path, which I think change each time, so instead of "If Wkb.Path = " maybe it should be something like "If Wkb.Path Like ", but don't know enough about the syntax to be sure of what's right. Still hoping for help.

Tried something different. When I originally worked on this code one of the suggestions was to use the Filesize, turn off Autosave for the Big Ones. So, I tried going that route with the code below (just starting it). For some workbooks I open it faithfully shows me the filesize, but for these sharepoint files it either gives an error ("Invalid Procedure Call") or doesn't do anything.

Please Login or Register  to view this content.