XL Automation - Member not found

  • Thread starter Thread starter Bill Schanks
  • Start date Start date
B

Bill Schanks

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(.ActiveWorkbook.Names.Count)

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_MEMBERNOTFOUND))
Exception Target Site: ForwardCallToInvokeMember

---- Stack Trace ----
System.RuntimeType.ForwardCallToInvokeMember(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_downloader.XLUpdate.Load_VGD_XL1()
Mainframe downloader.exe: N 00614
 
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?
 
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.

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 said:
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.
Click to expand...
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(.ActiveWorkbook.Names.Count)
Click to expand...
Any ideas what would cause this? I am running it via Early Binding (XL
2003).
Click to expand...
Exception Source: mscorlib
Exception Type: System.Runtime.InteropServices.COMException
Exception Message: Member not found. (Exception from HRESULT:
0x80020003 (DISP_E_MEMBERNOTFOUND))
Exception Target Site: ForwardCallToInvokeMember
Click to expand...
---- Stack Trace ----
System.RuntimeType.ForwardCallToInvokeMember(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_downloader.XLUpdate.Load_VGD_XL1()
Mainframe downloader.exe: N 00614
Click to expand...
Click to expand...
 
Back
Top