object disconnected from client error message

[Ken Warthen]

I've been working on an Excel 2007 data entry form that will be used to
update a password protected backend spreadsheet. Yesterday while testing the
application I started getting the following error message when loading the
form.

Error: -2147417848
Description: Automation error
The object invoked has disconnected from its clients.
Source: VBAProject
Procedure: cmdShowForm_Click
Module: Module1

I really don't know how to interpret this, or more importantly, how to fix
the problem. Any help will be greatly appreciated.

TIA,

Ken Warthen
(e-mail address removed)

 

[Bob Phillips]

How about the code?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ken Warthen]

Here's the code.

Sub cmdShowForm_Click()
On Error GoTo PROC_ERROR

frmDataInput.Show


PROC_EXIT:
Exit Sub
PROC_ERROR:
Call ShowError("Module1", "cmdShowForm_Click", Err.Number,
Err.Description, Err.Source)
GoTo PROC_EXIT
End Sub

 

[Ken McLennan]

G'day there Ken,

Error: -2147417848
Description: Automation error
The object invoked has disconnected from its clients.
Source: VBAProject
Procedure: cmdShowForm_Click
Module: Module1

I really don't know how to interpret this, or more importantly, how to fix
the problem. Any help will be greatly appreciated.

I had a similar issue with an automation project I'm working on
at present. My issues were caused by referring to unqualified methods
and properties. Have a look at this reference:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319832

The page is a bit heavy going, but I was finally able to filter
out what I needed to sort out my code. Of course, my project is still
not working but not for this reason any more

Hope it helps,
See ya
Ken McLennan
Qld, Australia