| 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 | |||
Linear Mode
