ashleywanless
Board Regular
- Joined
- Aug 4, 2009
- Messages
- 158
Hi All,
I have created an excel application which analyses some data held in SharePoint via a SharePoint list. It then creates an excel export and closes the initial workbook.
I have tried uploading this to SharePoint for use however this causes no end of errors which did not occur when i tested in excel. These errors are usually around objects not being recognised, i tried re-writing my code to dim excel as an application but this makes no difference.
Does Microsoft Office SharePoint Server 2007 allow workbooks with macros to be uploaded and run? Can anyone think of any other reason as to why this does not work?
Thanks
Ashley
I have created an excel application which analyses some data held in SharePoint via a SharePoint list. It then creates an excel export and closes the initial workbook.
I have tried uploading this to SharePoint for use however this causes no end of errors which did not occur when i tested in excel. These errors are usually around objects not being recognised, i tried re-writing my code to dim excel as an application but this makes no difference.
Does Microsoft Office SharePoint Server 2007 allow workbooks with macros to be uploaded and run? Can anyone think of any other reason as to why this does not work?
Thanks
Ashley