Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi
i wish to import 300 fields of data into a spreadsheet from a text file, but since spreadsheets are only 250 fields wide. i was wondering if there was anyway of writing a macro that could import the data vertically, so its all in one column or transpose it during importation. the cut and paste method is possible but i have 200 of these text files to import into this spreasheet and don't think this method would be best. thank you time and any effort that you spend on this matter its been much appreciated Jo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro/Method of Importing DATA in a loop | Excel Discussion (Misc queries) | |||
Importing and merging Excel files by using a macro | Excel Discussion (Misc queries) | |||
Importing data via macro | New Users to Excel | |||
Importing Data - Macro or Script | Excel Worksheet Functions | |||
importing data using a macro | Excel Discussion (Misc queries) |