Hello,
I have an Excel macro workbook stored on our SharePoint site. It copies data from that workbook to a separate .xlsx file also on SharePoint.
Once the data is copied, it does an "ActiveWorkbook.Save". When I run this on my local drive, it all works well. But when I run from SharePoint, that's where the problems arise.
It returns this message:
The problem appears to be that the destination workbook is read-only. So I modified my initial "open" statement to this:
Workbooks.Open myFileName, , False, , , , True ' where False is the "ReadOnly" parameter and True is the "IgnoreReadOnlyRecommended" parameter.
But this didn't work. I saw the same error message above.
So this brings me to my laundry list of questions:
Why does this work flawlessly when I run it on my local drive?
What is this file, 'C:\WINDOWS\system32\D5F95B10'. that it refers to on the error message when running from SharePoint?
Why does the file still open in read-only mode when the Open statement says "don't use read-only"?
And just to further complicate matters - a co-worker ran this from SharePoint, and it saved it to her desktop.
Thanks in advance for any insight, advice, and/or guidance you can provide!
Dennis
