Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Function
Message
From
15/11/2000 09:01:03
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00425616
Message ID:
00442054
Views:
8
>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
Map
View

Click here to load this message in the networking platform