Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
programatically selecting columns to import text into | Excel Discussion (Misc queries) | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
data import and text to columns | Excel Discussion (Misc queries) | |||
Selecting Active Cell before Text Import Routine | Excel Programming | |||
Import Text file into multiple columns | Excel Programming |