Importing all files in a folder to excel workbook

K

kmcosta

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.
 
F

Francisco Parrilla

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/viewtopic.php?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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import only files with a certain extension 1
Run macro on all files in a specific folder 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
Importing all components in a folder 1
20 excel workbooks every day to be summarized 1
Excel 2011 Mac - Import Worksheets into a Single File 0
copy data from one excel workbook to another workbook using macro 4
Excel 2007 macro: Dialogbox for saving a file as type Microsoft Ex 4

Top