SharePoint and Excel Macro Interactivity

Hi,

I have a report in Excel which I have published in MOSS (Microsoft Office SharePoint Server). Now the problem is that I have lot of Excel Macros which need to run based on the user input. It works fine in Excel, however, I am not able to replicate the same onto the Sharepoint.

In Sharepoint the report is just available on a viewable basis with no interactivity for the user to view the data as he would like to.

My question is

Is it possible to make the Excel Macros work in SharePoint. In a nutshell, can Excel and SharePoint communicate with each other, without the user having to download the Excel file to make the changes?

If this is not possible, what are the other available alternatives. Can the Excel macros be programmed in some other language so that the report can be made dynamic?

Any suggestions are greatly appreciated.

Cheers,
Abhi

Hi Abhi,

Not too sure if this is resolved. you can make excel macros work on MSSP sites. For example, you can save an excel file directly on SharePoint (i.e., upload the file from excel). Feel free to write to me if you need sample code for this.

Cheers, Anand

Originally Posted by AnandKumar

Hi Abhi,

Not too sure if this is resolved. you can make excel macros work on MSSP sites. For example, you can save an excel file directly on SharePoint (i.e., upload the file from excel). Feel free to write to me if you need sample code for this.

Cheers, Anand

Hi Anand,

Can you let me know how to work with it since i am a new user in sharepoint. I can develop macros on excel but the current problem which i am facing is i need a sharepoint frontend which opens as excel with fields and columns with validation and macro at the backend which will then consolidate since i would send the sharepoint link to users to update details on a monthly basis. Currently, we are in a havoc situation with only Excel as a messenger due to which version control and stuff has become a problem. I would need to use Sharepoint which will help me to solve the current problem. Any reply to this post would be helpful.

Hi , I am looking for a solution for similar kind of issue can anyone reply if you have th e solution? My macro to update a excel file in SP library works in one SP, but not in team SP. what could be reason.

Hey guys, sorry to bump such an old thread, but I am also interested in finding some help on this. Do you guys have any sample code I could work with?

Mainly, the issue is with the check out process. Not sure how to edit the code so that it downloads the file as a checked out one:

Sub test()
Dim wbname As String
wbname = "documentfromserver"
Workbooks.Open wbname

End Sub