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 (8...
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.
- Thats not really found the cause though, the program has to open several more files i would have major problems if i had to incorporate them into the main program, do you not think
