Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing data using a macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing data using a macro
You might want to have a look at this MS Knowledgebase article which
contains a macro for dealing with text files with more than 256 columns (up to 510). I haven't actually used this macro so I cannot vouch for it<g: http://support.microsoft.com/default...b;en-us;272729 -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |