How to hide workbook in background...

[Guest]

Hi,
I'm working with two workbooks. One has my macros the other has the data. I
assume in order to access the data in the data workbook it has to be open.
That said, is there a way I can hide the data workbook without first making
it active and then using ActiveWindow.Visible = False? I'd also like to make
it Visible again before I close it but not have to Activate it before doing
so.

Basically I want to make the opening of the data file as transparent to the
user as I can.

Thanks very, very much!
bd

 

[Die_Another_Day]

If you know the wb name, ws name and range then try J-Walks site:
http://www.j-walk.com/ss/excel/tips/tip82.htm

Otherwise try
Windows("OtherWorkbook.xls").Visible = False


Charles