J
Jesse
Is there a way to open a workbook in the background and have it not be
visible?
Jesse
visible?
Jesse
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rob Bovey
Jesse said: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 *
J
Jesse
This worked awesome, thanks Rob.
Jesse
Jesse
Rob Bovey said: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 *