open external workbook keep hidden

A function i'm producing opens a external workbook to retrieve some values from there, i would like to keep this workbook either invisible or minimized when it opens. Is this possible, ive done a similar thing in access.
ive tried the following approaches but with little joy, any other ideas

Workbooks.Open (FilePath2).application.visible = false
ActiveWindow.Visible = False
Workbooks.Application.Visible = False

some of these produce errors the other close both workbooks.
thanks

This works for me

Dim FilePath As String

Application.ScreenUpdating = False
FilePath = "K:\My Documents\Finance\Misc\Rear bedroom extension.xls"
Workbooks.Open FilePath
ActiveWindow.Visible = False
Application.ScreenUpdating = True


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cereldine" <cereldine.261pvc_1144668001.9615@excelforum-nospam.com> wrote
in message news:cereldine.261pvc_1144668001.9615@excelforum-nospam.com...
>
> A function i'm producing opens a external workbook to retrieve some
> values from there, i would like to keep this workbook either invisible
> or minimized when it opens. Is this possible, ive done a similar thing
> in access.
> ive tried the following approaches but with little joy, any other
> ideas
>
> Workbooks.Open (FilePath2).application.visible = false
> ActiveWindow.Visible = False
> Workbooks.Application.Visible = False
>
> some of these produce errors the other close both workbooks.
> thanks
>
>
> --
> cereldine
> ------------------------------------------------------------------------
> cereldine's Profile:
http://www.excelforum.com/member.php...o&userid=32069
> View this thread: http://www.excelforum.com/showthread...hreadid=531485
>