Excel - importing multiple text files into Excel with corresponding filenames
Asked By avi
03-Feb-10 03:56 AM
Dear members,
I need to import 100+ text files into Excel.
In addition I want EACH Excel column to show corresponding filename
too (where the data comes from).
How do I accomplish this?
TIA
avi replied to avi
Correction:
In addition I want EACH Excel ROW to show corresponding filename
(where the data comes from).
instead of
Files are comma delimited
Jacob Skaria replied to avi
Check out your other post. There is no need to multi-post .
--
Jacob
excel row? Excel how i can move to the end row directly in excel Excel Miscellaneous Discussions Max (1) Xdemechanik (1) Kkkkk (1) Try pressing CTRL + Down arrow - - Max Singapore http: / / savefile.com / projects / 236895 xdemechanik - -- keywords: excel, row? description: how i can move to the end row directly in excel
read the values from a excel row Excel hi I am trying to read the values from a excel row. There are 89 columns for each row and same number of data in each rows. Kindly help regards shantanu Excel Worksheet Discussions Word (1) Devenshire (1) Shane (1) Hi, What do you mean by "read Also why multi-posting is a bad idea. NickHK keywords: read, the, values, from, a, excel, row description: hi I am trying to read the values from a excel row. There
read the values from a excel row Excel hi I am trying to read the values from a excel row. There are 89 columns for each row and same number of data in each rows. Kindly help regards shantanu Excel Programming Discussions OssieMac (1) FirstColumn (1) NumbColumns (1) RowNumber (1) Vals (1) Len (1) Jkorpela 1), Cells(1, 89)).Value 'Note you get a 2-D array even for one row Debug.Print Vals(1, 29) Maybe look at Transpose also. Also, if you must post
reference every other row Excel Excel 2007 - I need to do a reference on every other row for another column to bring over some data. So for example: row 1 Column A Column B row 2 4229 row 3 $1000 row 4 5667 row 5 $2500 So I want in row2 column C "4229" and in
Excel 2007 Can not insert row. Excel Excel 2007. When I try to insert a row, the following notation comes up: 2000 etc. Excel Miscellaneous Discussions Excel (1) i don't know whether to call this a glitch or not. it has will allow you to insert rows. don't make logical sense, but it works keywords: Excel, 2007, Can, not, insert, row. description: Excel 2007. When I try to insert a row