Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel changes file modified date when opening my add-in
Stephen,
I think this is a Windows feature not Excel. Why don't they detect? If they open the newer one, problem solved? If they don't, the date is not modified? Don't quite see the problem. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Stephen K." wrote in message ... I have an Excel add-in that runs from the users PC and checks a network location for a newer version of itself each time it runs. If the network version's file modified date is newer, it calls a batch file to replace itself. The problem is, as I was testing it, I realized Excel changes the file modified date of my add-in when it is loaded and then changes it back as soon as Excel is closed and the add-in is unloaded. Thus, when I put a newer version on the network, no one's PC versions will detect it as newer. All I found in the kb was #245420 and it doesn't give me a workaround. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel changes file modified date when opening my add-in
No, I believe that Excel does this -- when you open a file, it changes the date/time to the time
it was opened. Then it sets it back to the original if you close without saving it. On Tue, 15 Jul 2003 00:08:49 +0100, "Bob Phillips" wrote: Stephen, I think this is a Windows feature not Excel. Why don't they detect? If they open the newer one, problem solved? If they don't, the date is not modified? Don't quite see the problem. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel changes file modified date when opening my add-in
Put a shortcut to the central addin in the users addin folder.
That way the central addin is always loaded and you dont have to worry about swapping versions. If you need to set users' preferences between uses of the addin use the registry, not fields in the addin. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Bob Phillips" wrote: Stephen, I think this is a Windows feature not Excel. Why don't they detect? If they open the newer one, problem solved? If they don't, the date is not modified? Don't quite see the problem. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Stephen K." wrote in message ... I have an Excel add-in that runs from the users PC and checks a network location for a newer version of itself each time it runs. If the network version's file modified date is newer, it calls a batch file to replace itself. The problem is, as I was testing it, I realized Excel changes the file modified date of my add-in when it is loaded and then changes it back as soon as Excel is closed and the add-in is unloaded. Thus, when I put a newer version on the network, no one's PC versions will detect it as newer. All I found in the kb was #245420 and it doesn't give me a workaround. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Updating Modified Date When I Don't Save File | Excel Discussion (Misc queries) | |||
Need to insert file modified date of Excel spreadsheet in a cell | Excel Discussion (Misc queries) | |||
Excel File Open Box - want Date Modified | Excel Discussion (Misc queries) | |||
How do I add the file last modified date into an Excel header? | Excel Discussion (Misc queries) | |||
How do I turn on the Last Modified option when opening a file? | Excel Discussion (Misc queries) |