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?

 

[JazzSP8]

Hi Andy

I've got a few workbooks that open other workbooks, with Screenupdating switched off the only clue I have is when it appears on the Windows taskbar.

Is this what you want to try and avoid?

You can hide the taskbar using; 'Start > Settings > Taskbar and Start Menu Properties'

You should have the option to autohide the taskbar which means that it dissapears when the mouse pointer isn't in that area.

 

[Andrew Poulsom]

This worked for me:

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

 

[andyjames]

Thank you for your suggestions.
I have the following code that is activated in by a button in a workbook.
However the new spreadsheet "calendar" is still shown between is being opened and closed.
Can anyone help further?

strFilePath = "c:\"
Public Const WbCal = "Calendar.xls"
wbCalendar = strFilePath & "Calendar.xls"
Application.ScreenUpdating = False
Application.DisplayAlerts = False

Workbooks.Open wbCalendar
ActiveWindow.Visible
Workbooks(WbCal).Close

 

[jim may]

Following the Workbook Open line
enter:
ActiveWindow.Visible = False

 

[Richard Schollar]

Another option would be to save the Calendar.xls down in a hidden state (ie much like the Personal.xls default setting) so that it opens up hidden too. Then you wouldn't need any additional code (altho the workbook will naturally open up hidden if opened directly from the File>Open menu).

 

[andyjames]

how would i do that?
the previous code works, but the file is still shown temporarily.

 

[Richard Schollar]

With Calendar.xls open within Excel, go Window>Hide and hide it. Then shut down Excel and when prompted whether you want to save changes to Calendar.xls click Save. If you open it up now, it will open up hidden (so you won't see it). Note that this can be very confusing especially to users who aren't aware of hidden workbooks.

 

[MaryJS]

This worked for me:

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

This code works great for opening the source workbook, but how do I set it back to normal and close it at the end of the code? I tried Workbooks.Close, but got an error.

Thank you!

 

[Andrew Poulsom]

Did you try?

Workbooks("BOOK1.xls").Close