XL Automation - Member not found

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bill Schanks
    #1

    XL Automation - Member not found

    I have a couple of users that are running a vb.net 2005 application,
    and @ 6:00am when they are trying to run the automation they are
    getting the below error. But when I get in and they try to run it
    again there is no error.

    The actual code that is running I think is this line (I can't tell the
    actual line, as I can't replicate the error):
    iNamesCount = CShort(.ActiveW orkbook.Names.C ount)

    Any ideas what would cause this? I am running it via Early Binding (XL
    2003).

    Exception Source: mscorlib
    Exception Type: System.Runtime. InteropServices .COMException
    Exception Message: Member not found. (Exception from HRESULT:
    0x80020003 (DISP_E_MEMBERN OTFOUND))
    Exception Target Site: ForwardCallToIn vokeMember

    ---- Stack Trace ----
    System.RuntimeT ype.ForwardCall ToInvokeMember( memberName As String,
    flags As BindingFlags, target As Object, aWrapperTypes As Int32[],
    msgData As MessageData&)
    Mainframe downloader.exe: N 00438
    Excel.Names.get _Count()
    Mainframe downloader.exe: N 00000
    Mainframe_downl oader.XLUpdate. Load_VGD_XL1()
    Mainframe downloader.exe: N 00614
    Tags: None
    • =?Utf-8?B?RmFtaWx5IFRyZWUgTWlrZQ==?=
      #2
      RE: XL Automation - Member not found

      Not a lot to go on, but, Downloader.exe, to me, implies you are getting
      either a spreadsheet or data from a server. What happens if the server is
      down, hiccoughs, etc...? Are there serverlogs that are accessable?

      "Bill Schanks" wrote:
      I have a couple of users that are running a vb.net 2005 application,
      and @ 6:00am when they are trying to run the automation they are
      getting the below error. But when I get in and they try to run it
      again there is no error.
      >
      The actual code that is running I think is this line (I can't tell the
      actual line, as I can't replicate the error):
      iNamesCount = CShort(.ActiveW orkbook.Names.C ount)
      >
      Any ideas what would cause this? I am running it via Early Binding (XL
      2003).
      >
      Exception Source: mscorlib
      Exception Type: System.Runtime. InteropServices .COMException
      Exception Message: Member not found. (Exception from HRESULT:
      0x80020003 (DISP_E_MEMBERN OTFOUND))
      Exception Target Site: ForwardCallToIn vokeMember
      >
      ---- Stack Trace ----
      System.RuntimeT ype.ForwardCall ToInvokeMember( memberName As String,
      flags As BindingFlags, target As Object, aWrapperTypes As Int32[],
      msgData As MessageData&)
      Mainframe downloader.exe: N 00438
      Excel.Names.get _Count()
      Mainframe downloader.exe: N 00000
      Mainframe_downl oader.XLUpdate. Load_VGD_XL1()
      Mainframe downloader.exe: N 00614
      >

        Comment

        • Bill Schanks
          #3
          Re: XL Automation - Member not found

          The application is called mainframe dowloader... The application
          downloads the file via ftp, and the part is fine. But the error is
          coming up while automating Excel to insert the data into the
          spreadsheet. I know it's not a lot to go on, but that is all I have as
          well. I can only guess where the code is breaking based on the stack
          info I provided, and the fact I can't replicate the error.

          On May 29, 11:01 am, Family Tree Mike
          <FamilyTreeM... @discussions.mi crosoft.comwrot e:
          Not a lot to go on, but, Downloader.exe, to me, implies you are getting
          either a spreadsheet or data from a server. What happens if the server is
          down, hiccoughs, etc...? Are there serverlogs that are accessable?
          >
          "Bill Schanks" wrote:
          I have a couple of users that are running a vb.net 2005 application,
          and @ 6:00am when they are trying to run the automation they are
          getting the below error. But when I get in and they try to run it
          again there is no error.
          >
          The actual code that is running I think is this line (I can't tell the
          actual line, as I can't replicate the error):
          iNamesCount = CShort(.ActiveW orkbook.Names.C ount)
          >
          Any ideas what would cause this? I am running it via Early Binding (XL
          2003).
          >
          Exception Source: mscorlib
          Exception Type: System.Runtime. InteropServices .COMException
          Exception Message: Member not found. (Exception from HRESULT:
          0x80020003 (DISP_E_MEMBERN OTFOUND))
          Exception Target Site: ForwardCallToIn vokeMember
          >
          ---- Stack Trace ----
          System.RuntimeT ype.ForwardCall ToInvokeMember( memberName As String,
          flags As BindingFlags, target As Object, aWrapperTypes As Int32[],
          msgData As MessageData&)
          Mainframe downloader.exe: N 00438
          Excel.Names.get _Count()
          Mainframe downloader.exe: N 00000
          Mainframe_downl oader.XLUpdate. Load_VGD_XL1()
          Mainframe downloader.exe: N 00614

            Comment

            Previous template Next
            Working...