Go to the filename specified in a cell

[lealea1982]

Hello,

I already have a macro that will open a file, the name of which is specified in cell A3 of my workbook (as it is subject to change). Now I just need my macro to activate the newly opened workbook at various points later on in the code. This is the code I have so far...

Please Login or Register  to view this content.

All I need now is to activate strFName basically, but I'm not sure of the code?

Many thanks for your help!

[ragulduy]

One method:

Please Login or Register  to view this content.

alternatively:

Please Login or Register  to view this content.

[lealea1982]

Thank you for your help. I did think it'd be something as simple as that, but it doesn't seem to be working though. With the first option I get Run-time error '9': Subscript out of range. With the second I get Run-time error '424': Object required.

[ragulduy]

I'm a bit of a loss to be honest, only thing I can see wrong with the code I did is you need a set of brackets in the second code:

Please Login or Register  to view this content.

and you might need to define wbstrFname

[lealea1982]

I'm at a loss too. If I use the 2nd option (with the brackets) it will error if the workbook is already open (which at times it may well be), but when I just want it to activate strFName it just keeps coming back with run-time error 9. It seemed like such a simple idea!

[lealea1982]

Oh, I've cracked it. It was

Please Login or Register  to view this content.

Thanks for your help!