The annoying in-the-stream ads

[Oorang]

The avatar IS pretty awesome. I love GetFuzzy

 

[kruiser]

Hi,

I was trying to run the "Bleeding Nose" macro mentioned by Erik above, but am having some problems.

I have windows XP running and when i try to run this macro, i get following error -

Run Time error '21....'
Method Close of object '_Workbook' failed.

This occurs at line -

WB.Close False

when i try to close the application.

I will appreciate if any-one can direct me to a resolution for this issue?

 

[erik.van.geit]

Hi, kruiser
Welcome to the Board !!!!!

what a question to make your entrance on the board
when you check the code, you will find

    'automatisation error if user closed WB "while bleeding"
    'same error checking if WB is still open
    'On Error Resume Next didn't work
    'not a big issue anyway :-)

because it is only a joke, I never took the time to solve it
I tried again for half an hour, but didn't find a way and do not see a reason. sorry

kind regards,
Erik