opening and hiding workbook

[wtnelso]

Hello,

I'm trying to open a workbook and pull data from it, but when I do that, it always opens in the way. I want to try to find a way to minimize the workbook that I am pulling data from. Here is what I have so far... The bold, underlined line is what I'm trying to use to do this, but it doesn't work.

Dim MY As Workbook
Dim FIMS As Workbook
Set MY = ActiveWorkbook
Set FIMS = Workbooks.Open(Filename:= _
    "C:\Documents and Settings\FIMS\FIMS - Consolidated .xlsx")

[U]FIMS.Visible = False
[/U]

 

[jeffmb]

Try:

Application.Visible = False

don't forget to make it visible sometime down the road.