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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,095,931
Messages
5,447,380
Members
405,449
Latest member
Jfrusty

This Week's Hot Topics

Top