MARCO TO Importing text file by specifying your columns

[nilaja]

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

 

[David McRitchie]

Hi Nilaja,
Simply record a macro, delete the columns (and possibly rows)
you don't want, then end the recording.

For others who may not be familiar with macros.
Getting started with macro
http://www.mvps.org/dmcritchie/excel/getstarted.htm