[RESOLVED] Load workbook invisibly

[Daniel McCool]

How can I load a workbook without the user seing it? Also, how could I load a spreedsheet in this manner as well?

For now, the main workbook does this to access the data information from the second workbook....

1. Open data workbook
2. Copy data spreedsheet
3. Hide data spreedsheet
4. Close data workbook

....works, but when the main workbook opens you can also see the second workbook open and all that mess while it's working. I'd like the user to open the main workbook and have the needed spreedsheet added without the visual display.

[RobDog888]

I don't think you can do it hidden from within the Excel app. I do
know that you can do it from vb. Maybe have a custom button to
execute your vb which will load the wb invisibily.
Add a reference to "Microsoft Excel xx.x Object library"

Option Explicit
 
Private Sub Command1_Click()
    Dim oXL As Excel.Application
    Dim oXLWB As Excel.Workbook
    Set oXL = New Excel.Application
    Set oXLWB = Workbooks.Add("D:\My Documents\Book2.xls")
    oXL.Visible = False
    MsgBox "Book2 loaded hidden!", vbOKOnly + vbInformation
End Sub

[TheFIDDLER]

I think this will go a long way with what you are doing:

application.screenupdating = false

Provided, you are back in your original workbook at the end of your code, the user will never know the focus temporarily moved to a second workbook. Also will clear up that "mess" of stuff moving around that you refered to. Will also speed up your code.

This is a code bit that you don't have to reset to true, it is automatically reset with the end of your subroutine.