Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
accessing text import wizard in VB
Hello,
I analyze external text files with Excel (using the common input routines of vb; filtering certain data before importing them into a spreadsheet; i.e. I do not import the whole file). To do this, I have to know the structure of the text files (delimiter, length of data entries, etc.). The build-in "text import wizard" does exactly what I need: Show the first entries, give the choice of delimiter, length etc. However, I do not want to import the file itself. I only have to know the structure of the datasets. So my question: Is there a way to access the "text-import-wizard" as a function, returning the parameters I need (i.e. the parameters which one could use for the "opentext"-command) without finally importing the text file? Many thanks for your help! Marko |
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 | |||
Help with 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) |