Excel 2007 to 2010 Issue

[GQue]

Well, I have an issue with some code that works perfectly fine in Office 2007, but since I upgraded to Office 2010, the code now fails. Oddly, it fails when calling a Sub in my code and not at a specific area in the code.

Error messge:

The object invoked has disconnected from its clients
​

Now I read several blogs that talk about Option Explicit being required (it is in my code).

Only thing I can point out is the sub being called has an ADO DB Connection in it and it is the only location in the code that calls a DB connection.

Has anyone else had this issue? I can't understand why it works in 2007, but not in 2010.

Help pls! =)

 

[GQue]

Just tried that... still no change in the error...

 

[RoryA]

Weird. What if you change the name of the sub so it doesn't begin with Clear? (grasping at straws now)
If that doesn't work, would you be able to email the file for review?

 

[GQue]

I tried changing the Sub to GoClearAcctManagers and no luck...

I don't mind sending the file, but the problem is the import files are confidential information that I can not send. I will be happy to mock a couple files for the import if you'd like.

If you are fine with that, I will put the files on a ftp site for you to DL.

BTW - Thanks so much for your time!!

 

[GQue]

Files are here if you'd like to test...

http://www.qicwebdesign.com/junkfiles/MyTest.zip

 

[RoryA]

I can't replicate your error with that file. I would point out that you shouldn't use Integer for a row number variable - use Long - and it's not good practice to declare object variables As New. Declare them and initialise them separately.

 

[GQue]

Thank you for looking and the advise...

 

[GQue]

Ok... So after my 5th reboot since the original problem... It wanted to work this morning.

Sorry for wasting everyone's time and I do greatly appreciate your time and effort in helping me out.

=)