Software

General discussion

Gravatar
0 Votes
Locked

Executing Excel Macro's from ASP

By paritala ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Executing Excel Macro's from ASP

by DKlippert In reply to Executing Excel Macro's f ...

The 800a03ec error is listed as a JScript error using the apostrophe. Here's the suggested solution:
"Precede the single quotation mark in the grid column's header with two escape
characters "\\". For example, if a column's header is "Owner's E-mail," change
the header to "Owner\\'s E-mail."
Hope it helps.

gravatar
Collapse -

Executing Excel Macro's from ASP

by paritala In reply to Executing Excel Macro's f ...

The question was auto-closed by TechRepublic

gravatar
Collapse -

Executing Excel Macro's from ASP

by Cedric King In reply to Executing Excel Macro's f ...

"This error is referenced in Knowledge Base article Q1**974 and occurs because a single quote is in the expression or header for a field. The preceding error was generated because I missed a quote in the expression. If you need to output a single quote in an expression, then use two backslashes to prefix the quote. For instance, you may need to create an expression like Name's with a quote in it. To accomplish this you must use this syntax:
Name\\'s"

gravatar
Collapse -

Executing Excel Macro's from ASP

by paritala In reply to Executing Excel Macro's f ...

The question was auto-closed by TechRepublic

gravatar
Collapse -

Executing Excel Macro's from ASP

by paritala In reply to Executing Excel Macro's f ...

This question was auto closed due to inactivity

Back to Software Forum

Start or search

Related Discussions

Related Forums