Forum Discussion
Excel User Form
I have Created a program that has sucessfully used a Form to enter data for several years. Recently as soon as the Form is in Focus i receive an debug Form that states
Run-time error '-2147417848 (80010108)':
Automation error
The object invoked has disconnected from its clients
Can anyone help with a solution as this has only just started to appear over the last few days. I have other forms which are not affected in the same program
- Can you upload a copy of the workbook so that we can investigate the issue.
- Hi Doug
If I can give you a brief summary I use the program to upload wildlife sightings to a database which is also an Excel Workbook. The different Butterfly, Moths and Dragon fly Species are held on a nother File, so the Workbook opens, writes and saves to two Files. As the error claims that the client was disconnected. I added the Specie data to the main Workbook, so the Workbook that originally held the Specie data was causing the problem of Client disconnected . I would be quite happy to send the Workbook and the code if you still require it. I also use variable to use as a specific Workbook Worksheet detail. Hope this throws a little more light on the subject- I gather that you have worked around the problem by moving the Specie data to the main workbook. Unless there is some reason for wanting to keep it in a separate workbook, there is probably little point in trying to determine the cause of the issue.
