XL Automation - Member not found

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Schanks - 29 May 2008 15:58 GMT

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

Reply to this Message

Family Tree Mike - 29 May 2008 17:01 GMT

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?

> 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
[quoted text clipped - 23 lines]
> Mainframe_downloader.XLUpdate.Load_VGD_XL1()
> Mainframe downloader.exe: N 00614

Reply to this Message

Bill Schanks - 29 May 2008 18:08 GMT

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.microsoft.com> wrote:

> 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
[quoted text clipped - 27 lines]
> > Mainframe_downloader.XLUpdate.Load_VGD_XL1()
> > Mainframe downloader.exe: N 00614

Reply to this Message

XL Automation - Member not found

Free Magazines