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 |
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 |
All times are GMT +1. The time now is 02:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com