Hiding Workbooks  
Author Message
Perilmind





PostPosted: Tue Feb 01 11:53:27 CST 2005 Top

Excel Programming >> 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

Excel211  
 
 
Bob





PostPosted: Tue Feb 01 11:53:27 CST 2005 Top

Excel Programming >> 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)




> 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
>


 
 
James





PostPosted: Tue Feb 01 12:03:04 CST 2005 Top

Excel Programming >> Hiding Workbooks Thanks Bob, but how do I keep this open workbook Hidden while I work on it.



>
> Set wb = Workbooks("the_wb_name").Open
> ' do your stuff
> wb.Close
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>


> > 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
> >
>
>
>
 
 
Tom





PostPosted: Tue Feb 01 12:39:08 CST 2005 Top

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

--
Regards,
Tom Ogilvy




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

>
> >
> > Set wb = Workbooks("the_wb_name").Open
> > ' do your stuff
> > wb.Close
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >


> > > 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
> > >
> >
> >
> >