We occasionally receive files with fixed-width fields. I have some users who need to open these in Excel. They mostly know how to use the Excel Text Import Wizard for this situation, but they sometimes have trouble remembering how to start the wizard. I'd like to make this easier for them by altering the file extension of the received file.
Is there a file extension that will trigger the Text Import Wizard to open automatically without modifying the default "Open With" settings in Windows?
I've tried *.csv, *.dat, and *.txt, and they don't work for me here. The users need to be able to just double-click on the file and have Excel open (so *.txt and .dat fail) with the Text Import Wizard (.csv doesn't trigger the wizard).
Similar (but the same as) this question:
Automate Excel Text Import Wizard?
