Workbook
 

Writing a macro to avoid openeing the same file in excel.

Workbook
 

Dim wkbk as Workbook
On Error Resume Next
set wkbk = Workbooks("MyFile.xls")
On Error goto 0
if wkbk is nothing then
set wkbk = Workbooks.open Filename:= _
"C:\MyFolder\MyFile.xls"
End if
wkbk.Activate
--
Regards,
Tom Ogilvy

"Steven Chan" wrote in message
...
Writing a macro to avoid openeing the same file in excel.