Importing all files in a folder to excel workbook
 

I am VERY VERY VERY new to VB programming. I am looking to import all
5 text files from a folder and then sort them into 5 separate columns
in my workbook starting at A43 for the first file, B43 for the second
file, etc... 5 new text files will be placed in this folder everyday
with different extensions. One has extension .057, .092, .159, .278
and finally .714. I want the macro to only read the extensions from
these files and not what comes before the extension. Does this make
any sense? Any help would be greatly appreciated!!

K.

Importing all files in a folder to excel workbook
 

Revises this file or link

http://www.exceluciones.com/portal/v...?p=33922#33922

--
Atte.
?T Francisco T?
http://groups.msn.com/ExcelVbaMacrosOffice

El verdadero buscador crece y aprende, y descubre que siempre es el
principal responsable de lo que sucede.
Jorge Bucay

La oscuridad nos envuelve a todos, pero mientras el sabio tropieza en alguna
pared, el ignorante permanece tranquilo en el centro de la estancia.
Anatole France

Importing all files in a folder to excel workbook
 

it revises this file or link, it is an approach to what you want of joining
all the leaves in an alone one
http://www.exceluciones.com/portal/v...?p=33922#33922

--
Atte.
?T Francisco T?
http://groups.msn.com/ExcelVbaMacrosOffice

El verdadero buscador crece y aprende, y descubre que siempre es el
principal responsable de lo que sucede.
Jorge Bucay

La oscuridad nos envuelve a todos, pero mientras el sabio tropieza en alguna
pared, el ignorante permanece tranquilo en el centro de la estancia.
Anatole France