Run time error 2147417848

[dilla1988]

hey guys,

I get the above error with the message: The object invoked has disconnected from its clients.

I'm using this complex excel worksheet which was created by a guy before me. So I'm not sure what's happening inside of it in terms of codes.

It was running perfectly fine without errors until today, and spits out the above error.

debugging shows this.

Please Login or Register  to view this content.

underlined line is the yellow highlighted line in the VBA as error.

And also I tried running this on Excel2003 and it worked without problems. So my problem is how come it's not running on 2010.

Running on Excel2010 is the purpose and clients have the same.


any help would be appreciated.

Dilla

[HaHoBe]

Hi, dilla1988,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

P.S.: how can we know what´s in your sheet?

Ciao,
Holger

[dilla1988]

Hi Holger,

Sorry about the mismatch in formatting.
Below is the code.

So the contents in the sheet are some aircraft information with daily movement figures. field 10 has the sum of fields 8 and 9. So if this sum value is 0.000000 then that entire row is deleted.

So there is the primary worksheet where I input aircraft, runway and movement data. And then there is this 'construct' workbook where it does all the calculations and the sorting of data according to my input.

Now the error message comes up within the DeleteRowsBasedOnCriteria() as in below code.

When I press debug on the error message, it shows the yellow highlight in the underlined bold line below.

The funny thing is code works flawlessly on EXCEL 2003 version.

Please Login or Register  to view this content.

[dilla1988]

Hi, dilla1988,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

P.S.: how can we know what´s in your sheet?

Ciao,
Holger

Hey Holger,

Please see the edited post and my response.

Thanks,
Dilla

[HaHoBe]

Hi, dilla1988,

looking at it from the code alone I would try

Please Login or Register  to view this content.

or add a check for the last visible row in order to avoid going over the limit of rows when offsetting.

Ciao,
Holger

[dilla1988]

Hi, dilla1988,

looking at it from the code alone I would try

Please Login or Register  to view this content.

or add a check for the last visible row in order to avoid going over the limit of rows when offsetting.

Ciao,
Holger

Hey Holger,

I tried your code, but the same message comes up and Excel crashes.

Anyway do you know the reason behind the original code working fine on Excel 2003?

thanks Holger

[dilla1988]

Hey Holger,

I tried your code, but the same message comes up and Excel crashes.

Anyway do you know the reason behind the original code working fine on Excel 2003?

thanks Holger

Just peeked in before force closing ans saw that it's an issue with

Please Login or Register  to view this content.

[dilla1988]

Just peeked in before force closing ans saw that it's an issue with

Please Login or Register  to view this content.

Will it be useful if I share the whole folder of the calculation spreadsheets? so you have a better understanding?

cheers,

[Trebor76]

Hi dilla1988,

So column J has the values you want to base the deletion on? Do columns A to I have data (if they don't column J won't be the 10th field)? What is the range of your entire dataset?

Robert

[dilla1988]

Hi dilla1988,

So column J has the values you want to base the deletion on? Do columns A to I have data (if they don't column J won't be the 10th field)? What is the range of your entire dataset?

Robert

Hi Robert,

Yes Column J has the values that are the base for the deletion (which the code is saying to check IF 0.000000)

Column A-I have data on them.

I have attached the whole directory so you can see all the connected spreadsheets.

In the attachment, INM Builder 7.0 is the only file we use to input data. I have filled in the necessary information that should be sufficient to run it.
All you got to do is press process on the first tab.

Again I have no idea why this is not working on Excel 2010

thanks Robert.

[Trebor76]

Hi dilla1988,

It ran for me (though I have Excel 2007) without error

Robert

[dilla1988]

Thanks for trying it out Robert.

Strange! so I reckon it's an issue with Excel 2010 I'm having?? But it's doing the same with all the other machines in the office.
So on 2003 it runs fine too.

Any tickboxes or options I have to turn on/off in Excel 2010 related to VBA maybe?

[dilla1988]

Hi dilla1988,

It ran for me (though I have Excel 2007) without error

Robert

I was looking at References under Excel 2010 VBA and you reckon there is something there that could cause problems within 2010 version?

thanks,
Dilla

[Trebor76]

I was looking at References under Excel 2010 VBA and you reckon there is something there that could cause problems within 2010 version?

Only if any of them start with MISSING

Strange! so I reckon it's an issue with Excel 2010 I'm having??

Without having 2010 I can't offer a solution or advice I'm afraid

[dilla1988]

Only if any of them start with MISSING



Without having 2010 I can't offer a solution or advice I'm afraid

Thanks for that Robert,