Modify Text Import Wizard

[JBL]

I have a set up a button that opens xlDialogImportTextFile

So far so good it runs as designed but when I get to the
choice of delimiter types I have special files that use a
Character 238 as a text delimiter.

I can obviously cut and paste the delimiter into the
other box each time I run the text import wizard to parse
and import the data but I would think there is a command
option that can be added to the Application.Dialog(vb
constant).Show that would allow me to specify a default
other delimiter or at least add it to the drop down list
box.

Darn if I can figure out how to do it. Do I have to write
my own import routine? If so any ideas where to start?

Thanks
Jeremy

 

[BrianB]

Why not macro record the opening of a text file and use GetOpenFileName
instead.
You can hopefully change parameters depending on some content of the
file name, or use a custom dialog.