Hiding Workbooks
 

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

Hiding Workbooks
 

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

--

HTH

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


"James" wrote in message
...
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

Hiding Workbooks
 

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

"Bob Phillips" wrote:


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

--

HTH

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


"James" wrote in message
...
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

Hiding Workbooks
 

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

--
Regards,
Tom Ogilvy


"James" wrote in message
...
Thanks Bob, but how do I keep this open workbook Hidden while I work on
it.

"Bob Phillips" wrote:


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

--

HTH

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


"James" wrote in message
...
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