Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Text Import Wizard
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Text Import Wizard
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. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Text Import Wizard | Excel Discussion (Misc queries) | |||
Text Import Wizard | Excel Discussion (Misc queries) | |||
Text Import Wizard | Excel Discussion (Misc queries) | |||
Text Import Wizard | Excel Discussion (Misc queries) |