You have to figure out whether the workbook is open already or not and only
call the open method if it isn't already open - there is no such option.

On Error Resume Next
set wkbk = Workbooks("myfile.xls")
On Error goto 0
if wkbk is nothing then
set wkbk = Workbooks.Open( "C:\My Documents\myfile.xls")
Else
wkbk.Activate
End if


--
Regards,
Tom Ogilvy

"Daniel Wright" wrote in message
...
Hello,


In the word object model there is a property of the open method which
allows you to revert to the file if it is already open.

I can't find a similar property in the open method of the excel object
model; does anybody know if this is possible so that excel will revert
to the open workbook if it has already been opened.

Thanks

Daniel.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!