In microsoft.public.excel.misc on Tue, 10 Jul 2007, Jim Rech
wrote :
Hi Ron-

This isn't a big help but I find that, if I do a Data, Text to Columns and
specify the semicolon, then any text file imports I do after that the
semicolon remains selected. Excel 2003 anyway.

So you could 'prime' the text import wizard for an Excel session with this
macro:

Sub PrimeTextImport()
Workbooks.Add
ActiveCell.Value = "abc"
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited,
_
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Semicolon:=True
ActiveWorkbook.Close False
End Sub


Thanks for this.

Regards,
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)