How to ignore and proceed on run time error 91

Hi Friends,

Visiting here after long time as I got stuck at a place and need help. Thanks in advance.

Problem - I am trying to open a existing spreadsheet (lets call it exstnSpSht) through another spreadsheet (currOpnSpSht). This gives me an run time error - 91 with two options 'END' and 'HELP'. I know why is this error but I dont have control to fix this error, so Iwant to ignore by theoritically press 'END' when this error pops up and proceed further to do my other operations.

my small version of code :

Please Login or Register  to view this content.

ANy help is highly appreciated.

Best
Shammi

Thanks Raga. I tried it but it does not work in this situation.

The error actually happens while trying to open a file from workbooks.open function in currentsheet - which opens the file and runs a private subrouitine macro workbook_open() which has a object which is not set.

Hope this is making sense.

To help understand my problem. I have attached a file, which I cannot modify and have no control ( I only wish).

I am trying to open the attached file though my code that I copied above.

So if anyone wants to try and experience my problem and help.


Save this file in one of your folder.
Open a blank spreadsheet and open VBA copy my code.
and run it the code

Thanks
Shammi

Hahobe Hahobe --- Worked perfect - Thank you so much - I owe you a beer !!

Yeah figured that. thank you soo so much again Holger !