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