J
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
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