vba - opening workbooks without showing

[andyjames]

I have some code during which I open a workbook. however I do not want to show the workbook. i have tried getting both screenupdating and displayalerts to false but no success. can anyone help?

 

[MrHydrant1857]

This worked for me:

Sub Test()
    Workbooks.Open Filename:="C:\Temp\BOOK1.xls"
    ActiveWindow.Visible = False
End Sub

Andrew, i used this code and it worked, but i removed the activewindow code and now it wont open at all. it says its open but its nowhere to be found.

 

[lixfelix123]

Dim filetoopen As Variant
Dim opeenbook As Workbook

filetoopen = Application.GetOpenFilename(Title:="Browse For Your File", FileFilter:="Excel Files(*.xlsx),*xls*")

If filetoopen <> False Then
Set openbook = Application.Workbooks.Open(filetoopen)
openbook.Visible = False

why this code didn't work

 

[johnywhy]

Best solution i've seen. Actually opens workbooks without showing, (unlike the answers which claim to, but actually open it visible and hide it after).

Sub test()
          GetObject "C:\MyFile.xlsx" 'Workbook will remain invisible, no new window appears in the screen
End Sub

You can get the workbook object too, if you need it:

Sub test()
          Dim wb As Workbook
          Set wb = GetObject("C:\MyFile.xlsx") 
          Debug.Print wb.Worksheets(1).Name
          wb.Close
          Set wb = Nothing
End Sub

The only visible activity during the open is the standard progress-bar on lower right while opening. That can be eliminated with `ScreenUpdating=false` before the `GetObject` line.

The second best solution is for VBA to open a separate instance of Excel (using `GetObject`), and open your workbook inside that instance.

 

[johnywhy]

The second best solution is for VBA to open a separate instance of Excel (using `GetObject`), and open your workbook inside that instance.

i think you would do CreateObject to open the separate instance of Excel.