Hello,

I have an application controlled by a central XLA file that opens and controls many XLS files. Occasionally these files, even the XLA file, are upgraded and I need a method for my application to recognize this and download the appropriate file(s) from my webserver.

Questions:
1) What's these best fact to use as a version tester? Create date, modify date, or a version indicator within the file itself (ie a named range)? The filename itself does not indicate a version number. The name is always the same.
2) How can I replace the file that holds the actual code in the event it gets upgraded? I can't download it and replace it because it is currently open.

Any help would be apprecitated.