We have a VBScript called from desktops that writes start / end times to a tab delimited file (with an .xls extension) as a timelog.
When someone opens this file in Excel, and then wants to close it, it warns:
Are you sure you want to keep it in this format? You will lose things etc...
The issue is that if someone answers NO they aren't sure, it still saves as the same file name, but no longer tab delimited.
Can an individual file be flagged internally - or in some other way - so that saving in a format other than tab delimited is impossible? I realize this format will not allow me a macro on the before save event, so any other ideas?
Implementing this solution followup
As a warning, if you write to a file in csv format, as I did, remember, logging input such as currency, or content with commas in the input will alter the column layout. The solution is to wrap the input strings in quotes.