General information
Category:
COM/DCOM and OLE Automation
>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.
Sounds like you want to delete the file you've created no matter what the user does. Either she saves it to another file, in which delete this one, or she doesn't save it, in which case, delete this one. So, just wait until you've closed the file (or even close Excel) and delete the file from VFP.
Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only