object disconnected from client error message

K

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)
 
B

Bob Phillips

How about the code?

--
---
HTH

Bob


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

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
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top