Hiding Windows - Windows("Name.xls").Visible = False

I'm having trouble hiding some Excel windows.

I'm using the following code to hide a window:

Please Login or Register  to view this content.

It keeps throwing "subscript out of range" errors at me and I can't figure out why.

The filename is correct, so is the extension. I've used a MsgBox to tell me the caption of the window which also shows up the way I have typed it.

I have a macro, in another workbook, which opens this file automatically, but I can't set the Visible property for the Window.#

Ideas anyone?

If you use

Please Login or Register  to view this content.

to load this workbook it's automatically hidden

Ah, that's great.

Is there anything I should know about updating links and what not while using this method, or is it just the same?

I'm only referencing cells in formulae and it all seems to be working fine, but I'm just asking in case there are issues I could run into in the future.

You could also use:

Please Login or Register  to view this content.

Is there anything I should know about updating links and what not while using this method, or is it just the same?

As far as I know it's the same (except the visibility of course).

Ok thanks for the help. Problem Solved.