>What about a different instance...I copy a cursor to Excel, then issue the following:
>
> outfile=addbs(sys(2023)) + "ca_" + sys(2015)
> copy to (outfile) type xl5
> o=createobject("excel.application")
> with o
> .workbooks.add(outfile)
> ...formatting code...
> endwith
>
>
>This creates an excel file in my c:\temp\ directory, but I want this file deleted if the user doesn't save it under a different name. I don't want to clutter their hard drive. Maybe there's a better and completely different way to approach this? I'm not sure.
After formatting, save(outFIle). When user closes, delete (outfile)? Is there a Changed reference for the work sheet?
Imagination is more important than knowledge