Excel applications in SharePoint

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
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,250
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top