>Hi all,
>
>I have some code that has worked for nearly a decade but i've rolled it out in a new way recently for a customer. I have a form that has a timer on it that runs a method every 15 minutes. A second excel file reads from this first one but on occasion the file i am trying to update is open, if only briefly. What happens in this case is that the excel files opens in read only mode and then crashes at the end. I've tried fopen() and other parameters but nothing tells me that the file is already open. Anyone help?
>The code I use to open the excel file is
>

>mfilename = "myexcelfile.xls"
>oleapp = createobject("Excel.Application")
>oleapp.Application.Workbooks.Open(mfilename)
>

>
>~M

mfilename = "myexcelfile.xls"
IF NOT EMPTY(SYS(2000, mfilename))
   lnHandler = FOPEN(mfilename,12)
   IF lnHandler < 0 && Can not open this file
      **** 
   ELSE
      FCLOSE(lnHandler)
   ENDIF
ENDIF