Hide workbook
 

Is there a way to open a workbook in the background and have it not be
visible?

Jesse

Hide workbook
 

"Jesse" wrote in message
news:GvcAb.19157$bC.16307@clgrps13...
Is there a way to open a workbook in the background and have it not be
visible?

Hi Jesse,

Here's the general idea of how to do this. Be sure to change the
workbook path and name to fit your circumstances.

Sub OpenWorkbookHidden()
Dim wkbBook As Workbook
Application.ScreenUpdating = False
Set wkbBook = Workbooks.Open("E:\Book1.xls")
wkbBook.Windows(1).Visible = False
Application.ScreenUpdating = True
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

Hide workbook
 

This worked awesome, thanks Rob.

Jesse




"Rob Bovey" wrote in message
...
"Jesse" wrote in message
news:GvcAb.19157$bC.16307@clgrps13...
Is there a way to open a workbook in the background and have it not be
visible?

Hi Jesse,

Here's the general idea of how to do this. Be sure to change the
workbook path and name to fit your circumstances.

Sub OpenWorkbookHidden()
Dim wkbBook As Workbook
Application.ScreenUpdating = False
Set wkbBook = Workbooks.Open("E:\Book1.xls")
wkbBook.Windows(1).Visible = False
Application.ScreenUpdating = True
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *