Hi, this is what i have so far. I'm trying to open another workbook (oWB) and
read data from multiple sheets, the Populate fields in thisworkbook and close
oWB. oWB will sometimes be opened as read only because it is on a network.
And in the open code of oWB there is a read only check that gives me an
error. I need to open the workbook so the automatic "Open" event doesnt fire
(in oWB) how do i do this?. Thanks for any help!

MyPath = Application.GetOpenFilename(fileFilter:="Microsoft Excel Files
(*.xls), *.xls", Title:="Select File to Open...")
Set oXL = New Excel.Application
Set oWB = oXL.Workbooks.Open(Filename:=MyPath)

Also, will this keep oWB invisible? id like to keep it from poping up on the
screen.
and is it necessary for me to create a new application oXL? I took this from
another program i had that was written in VB from a word application so this
is why i am asking. thanks again!