System Error &H80010108 (-2147417848) object invoked disconnected client

**xclrInTraining** · 01-06-2010, 05:22 PM

Hi all,

Hoping you can help, as I am absolutely stumped. I have created workbooks for four health regions to collect data, which then needs to be resubmitted via FTP, but with de-identified data. The end users have little to no excel experience, thus had to make it simple as possible. Created a button that runs the macro (below) to deidentify (clear) all cells where there could possibly be personal identifying information. Runs fine on my cpu, but one user (so far) has received the error noted in the title. Both running excel 2003 with SP3 (I have version 11.8169.8172, user has 11.8316.8221), I have XP professional SP2, user has XP professional SP3. Spent hours searching and reading suggestions online, to no avail. Any simple solutions anyone can come up with would be truly appreciated.

Thank you in advance!

Please Login or Register  to view this content.

**broro183** · 01-06-2010, 06:08 PM

hi xlclr,

I'm not sure why I had the page open but by some coincidence, I had the below KB page open when I saw this thread - it may be of interest (I haven't read it all yet)...
http://support.microsoft.com/default...b;en-us;319832

Here's a shortened code which I think does the same as your original code:

Please Login or Register  to view this content.

hth
Rob

**xclrInTraining** · 01-07-2010, 05:18 PM

Your solution works beautifully, many thanks. Wish you were a Kiwi hiding in my office as opposed to the UK.

I've read the article in the link you provided, which wasn't quite as useful, more than likely due to my limited understanding of vba.

More for my own understanding and knowledge, where exactly was I guilty of "early binding" or an "unqualified reference".

Again, thanks... as far as grades go, 100% for sure. Well, 99%, it did take you over 40 minutes to post a response ;~p

**broro183** · 01-07-2010, 09:20 PM

Thanks for marking the post as solved

lol, be careful what you wish for - anything's possible!
Where did you say your office was...?

Ummm, Every reference to a range without a preceding workbook & worksheet (& in some cases a parent Excel App) can be considered "unqualified" which is why I've tied everything in using With statements. When Range statements are not "explicitly qualified" they default to the active sheet. My "ummm" is because I'm not sure why this would cause a problem in your situation where everything is done in one file & the focus is not changed during the macro...?
Perhaps it has something to do with the FTP, I'm not exactly sure of the context or of FTP, so I'm sorry I can't provide a clear answer.

On glancing at the code again, I would make a few changes as below & have included stream of consciousness comments too.

Please Login or Register  to view this content.

hth
Rob

**sudarshan1026** · 09-29-2013, 10:50 PM

Hi All,

I am using the below code, to copy data generated out of a web query. I have values in Col A which is the variable and generates data from web query on input.

i am getting the same error as in this thread except the undisconnected client.

Please Login or Register  to view this content.

Any help or guidance would be much appreciated please.

Sudi

**arlu1201** · 09-30-2013, 10:14 AM

Sudi,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.