>>>I came upon FileToStr() for situations like this because I needed a way to copy a file to a different directory, and Copy File was acting up on Excel sheets which were currently open, and FileToStr() and then StrToFile() was the solution.
>>>
>>>That's all I know :).
>>
>>Yes, it depends on the associated program that opens the file. AFAIK, Excel creates the temporary file and actually does not work with the original file until you want to save it. But many other programs like FTP or DOS commands with redirected output to file, they do not allow to work with this file while in process of writing.
>
>But Excel still wouldn't let me Copy File that it had open. So even if it works off a temp file, it still has a handle to the original - probably to signal to other users that it's open and to offer to open readonly.
Probably it depends on the Excel version. At least for me it works: I have the Excel file opened, the cell selected and text and cursor inside the cell; nevertheless, the copy file command works from vfp command window.
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