Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 563
  • Last Modified:

Excel in Sharepoint - PLEASE

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
0
Rayne
Asked:
Rayne
1 Solution
 
apache09Commented:
There usually two way a user can open/edit a office document/file from share point

They can open it directly, in which case its opened locally, make changes and save over the copy in the sharepoint location.

they can check out the document/file
Once checked the file is saved to the local
The File In Sharepoint shows it as being checked out, limiting other users access to open and edit the sharepoint copy

Once they have made their changes, they can save
Once saved they have to check the file/document back into sharepoint for others to see changes


Now the bit on the MAcros
Macros are local to the PC and not shrepoint or its file location
Once the document is open, macros are bing run in the local copy/version
0
 
RayneAuthor Commented:
Thank you Apache09 ;)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now