| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
programatically selecting columns to import text into
Hi,
I am writing a macro to import multiple text files into a spreadsheet. The only part I haven't figured out is how to step sideways, i.e the first text file should use A1 as its origin, the second file C1, the third E1 and so on. Range(A1).Select Range(C1).Select Range(E1).Select /Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text import wizard defaults? | Excel Discussion (Misc queries) | |||
| Import comma delimited text | Excel Discussion (Misc queries) | |||
| Excel Text Import Wizard | Excel Discussion (Misc queries) | |||
| import data to specific columns | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
