I often have to download text files from a mainframe that are then to be opened in Excel using the Text Import Wizard.
To save time, I thought it would be useful to set an alternative file association for txt files so that I could right click and 'open in Excel' - rather than having to open Excel, use the 'Open File' dialogue to navigate to the folder, change the 'files of type' etc etc.
My problem is that if I set the file association to excel.exe it bypasses the Text Import WIzard, and dumps each line in column A - Is there a way of forcing excel to use the Text Import Wizard when opening a file?
Are there DDE settings I could use? - I can't see any switch settings that will force the use of the Wizard.
I know I could simply use the 'text to columns' wizard after opening the file, but a one-click solution would be useful.