In our project we have all our reports in Excel. We need to format it in certain way. In format we are using some sub totals and other stuff. In the process I am using Page Setup also for getting header and footer and getting Landscape format.
Icreated a macro for this format this macro is working fine if we are executing from Visual Basic but it is fails if we are running from ASP and the following error i am getting , Could you help me out in this issue . For your reference i am giving my macro code here .
I appreciate your help.
******************************************************************************
The Following error i am getting if i am running from ASP
Microsoft Excel error ‘800a03ec’
Unable to set the LeftHeader property of the PageSetup class
*******************************************************************************
*************************************************************************
The following routine is used in my DLL ( I tried inboth No Compatibilit
