<div>
<div class="content wysiwyg-content">
To All VBA &amp;&nbsp;Sharepoint &nbsp;Gurus,<br />
<br />
I had a question that is bugging and I know only EE's forum and your kindness will get me out of this confusion.<br />
<br />
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. <br />
<br />
So questions or my assumptions are - <br />
correct e if I &nbsp;am wrong:<br />
<br />
1. When users click on the hsarepoint file &nbsp;- 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?<br />
<br />
2, macro code works alright in that temp folder file?<br />
<br />
Thanks a million,<br />
From the guy, who day dreams sometimes and sometimes procrastinates
</div>
</div>


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

Excel in Sharepoint - PLEASE

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.