M
Marko Marquardt
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
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