Excel in Sharepoint - PLEASE
Posted on 2013-06-30
To All VBA & Sharepoint Gurus,
I had a question that is bugging and I know only EE's forum and your kindness will get me out of this confusion.
So I have got a excel macrobook that is currently stored in a sharpeoint folder. The way folks will use it - they will go to the sharepoint and click on the workbook. After it opens, they make changes to the workbook and then press some macro buttons andclick on the save button in the excel file after making their changes.
So questions or my assumptions are -
correct e if I am wrong:
1. When users click on the hsarepoint file - at that time, it downloads a local copy of the excel to the users temp folder and then as they make and save change, it get saved to shareopint from that temp folder?
2, macro code works alright in that temp folder file?
Thanks a million,
From the guy, who day dreams sometimes and sometimes procrastinates