General discussion

  • Creator
    Topic
  • #2081879

    Executing Excel Macro’s from ASP

    Locked

    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

All Comments

  • Author
    Replies
    • #3768848

      Executing Excel Macro’s from ASP

      by dklippert ·

      In reply to Executing Excel Macro’s from ASP

      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.

    • #3852682

      Executing Excel Macro’s from ASP

      by cedric king ·

      In reply to Executing Excel Macro’s from ASP

      “This error is referenced in Knowledge Base article Q191974 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”

    • #3852652

      Executing Excel Macro’s from ASP

      by paritala ·

      In reply to Executing Excel Macro’s from ASP

      This question was auto closed due to inactivity

Viewing 2 reply threads