PRODUCT  :  QUATTRO PRO                            NUMBER  :  194
VERSION  :  ALL
     OS  :  MS/PC DOS
   DATE  :  April 5, 1991			     PAGE  :  1/1

  TITLE  :  FILE FIND MACRO




This is a macro for checking whether a spreadsheet is currently
opened or closed in Quattro Pro.  The macro beeps when a
spreadsheet named FILENAME is currently open, or executes a macro
named FILE NOT OPEN when it is not.

A11: 'FINDFILE
B11: '{choose}
B12: '{edit}
B13: 'FILENAME
B14: '{CR}
B15: '{if
@iserr(@find("FILENAME",@curvalue("file","save"),0))}{file not
open}
B16: '{beep}


In your spreadsheet, the macro will appear as follows:

FILEFIND	{choose}
		{edit}
		filename
		{CR}
		{if
@iserr(@find("FILENAME",@curvalue("file","save"),0))}{file not
open}
		{beep}


To test for an open file, the FILEFIND macro should be in your
current spreadsheet.  Change the cell containing the label
filename to the name of the file to check.  To execute this
macro, select / <T>ools <M>acro <E>xecute FILEFIND and press
<Enter>.