MARCO to import text by selecting columns
-----Original Message-----
Hello everyone,
i have a macro that imports a text file and i have to
manually run the wizard to select my columns. The text
imports 5 columns and i have predefined the Marco to
copy
it to cell
Set DestCell = Range("C1:E119")
it works well, but i will like the macro to only select
this range, without me manually skipping the first and
last column before importing the text file. the
information i need for the text files are in three
middle
columns. and the first and last columns are not needed..
Thanks in advance
.
|