Can DOS close an open file?

quattro20v · #1 (**permalink**) 12-31-2008

I'm trying to setup a cron job for my brother that goes out to the web and retrieves an excel file and overwrites the existing copy on his desktop. The problem I'm facing is I have to kill the process (excel.exe) if the file is open while the batch file runs, otherwise, it will create another copy with a 1 or 2 or 3, etc appended to the end of the filename. For example, the correct filename would be myfile.xls and it will create myfile.xls(1). So, I kill the process before it goes out to the web to retrieve the file. This works, but ideally, I would like to close that particular file without killing the process in the event he has other files in open state . . . is this possible?

reborg · #2 (**permalink**) 12-31-2008

Not easily and not directly through DOS. You would have to write a control for excel to close and reopen the file.

bakunin · #3 (**permalink**) 01-01-2009

You might try the following:

The cron job first retrieves the file and saves it locally under a unique name. Then it runs a loop which terminates as soon as the excel.exe process goes away and then moves the file to the final destination. In pseudocode:

Code:

get_file_from_internet()
save_file( "some_unique_name" )
while ( excel.exe is running ) {
     wait()
}

move_file( "some_unique_name", "myfile.xls" )
end()

Depending on the frequency of how often the cron job runs and how often it gets a new version of the file you might have to implement some sort of locking mechanism because a cron job could already be waiting to replace the file when the next one starts and retrieves an even newer version of the file.

I hope this helps.

bakunin

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Number of open files (Dir's) how to close?	satyam90	UNIX for Advanced & Expert Users	1	11-07-2008 09:17 AM
close open files before remove	xramm	SUN Solaris	9	09-14-2007 08:23 AM
Close Socket at HP-UX	Renato Gregio	HP-UX	2	08-14-2007 10:04 AM
Should a UNIX daemon process close open fds?	kunalashar	UNIX for Dummies Questions & Answers	1	10-24-2002 09:10 AM
File status - open/close ??	Pal	UNIX for Dummies Questions & Answers	3	09-26-2001 03:54 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by