Hiding Workbooks

[Guest]

Hi
Could someone please adbvise on the following
* I would like to open a Excel workbook from within another workbook. It
contains data & would like it to be hidden
* would perform some searches on this hidden Data workbook from calling
workbook (can I do that)
* once done would like close this hidden datda workbook

Thanks a lot

 

[Bob Phillips]

Set wb = Workbooks("the_wb_name").Open
' do your stuff
wb.Close

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks Bob, but how do I keep this open workbook Hidden while I work on it.

 

[Tom Ogilvy]

Set wb = Workbooks("the_wb_name").Open
wb.Windows(1).Visible = False
' do your stuff
wb.Close