I have developed a VBA project.It runs fine on my PC. I
have created and tried to run the project on that PC. but
i am getting an error with above code.The error message
says " The Object involved has disconnected from its
clients" . This is very critical for me. Please Help

Statr the workbook without activating macros and open the
project window, check that you have all necessary library
referrences. Tool | References look for any ticked item
with the words MISSING

regards
KM

-----Original Message-----
I have developed a VBA project.It runs fine on my PC. I
have created and tried to run the project on that PC. but
i am getting an error with above code.The error message
says " The Object involved has disconnected from its
clients" . This is very critical for me. Please Help
.

Hi KM,
Thanks for your reply.I couldn't find any ticked item
with the words Missing what could be the problem?

-----Original Message-----
Statr the workbook without activating macros and open the
project window, check that you have all necessary library
referrences. Tool | References look for any ticked item
with the words MISSING

regards
KM

-----Original Message-----
I have developed a VBA project.It runs fine on my PC. I
have created and tried to run the project on that PC.
but
i am getting an error with above code.The error message
says " The Object involved has disconnected from its
clients" . This is very critical for me. Please Help
.

.

Hi KM,
I have removed all the unnecessary references from the
project. Now it works. Thank you for the hint

Thanks & Regards
Praveen


-----Original Message-----
Hi KM,
Thanks for your reply.I couldn't find any ticked item
with the words Missing what could be the problem?

-----Original Message-----
Statr the workbook without activating macros and open
the
project window, check that you have all necessary
library
referrences. Tool | References look for any ticked item
with the words MISSING

regards
KM

-----Original Message-----
I have developed a VBA project.It runs fine on my PC. I
have created and tried to run the project on that PC.
but
i am getting an error with above code.The error message
says " The Object involved has disconnected from its
clients" . This is very critical for me. Please Help
.

.

.

I had the described error after the battery on my laptop when US. when
restarted, the spreadsheet was locked and marked as read only. I trie
the tips about deleting the temp versions, but could not find th
files. In the end I

Used AltCNTLDEL to kill off a rogue Excel process which had appeare
from somewhere. This allowed me into the spreadsheet however when I ra
it, I got the disconnected error (I have forgotten number and canno
recreate)

Next I made sure that all Excel sessions were closed (AltCNTLDEL) an
then reopened the spreadsheet disabling macros on the way in

Next I went into the VB editor and exported all modules and userforms
Then exited

Next create a new sheet and import each of the entities to create th
application.

It took a few minutes to do, but all now seems well

--
Message posted from http://www.ExcelForum.com