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
Procedu 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

How about the code?

--
---
HTH

Bob


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



"Ken Warthen" wrote in message
...
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
Procedu 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

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


"Bob Phillips" wrote:

How about the code?

--
---
HTH

Bob


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



"Ken Warthen" wrote in message
...
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
Procedu 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

Does the code get into the form, or does it error on the call? If the
former, what is in the form, code and functionality wise.

--
---
HTH

Bob


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



"Ken Warthen" wrote in message
...
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


"Bob Phillips" wrote:

How about the code?

--
---
HTH

Bob


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



"Ken Warthen" wrote in message
...
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
Procedu 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

G'day there Ken,

Error: -2147417848
Description: Automation error
The object invoked has disconnected from its clients.
Source: VBAProject
Procedu 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...;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