Importing all files in a folder to excel workbook

  • Thread starter Thread starter kmcosta
  • Start date Start date
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.
 
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
Custom Document Properties in Word documents and Excel workbooks 13
Run macro on all files in a specific folder 3
Import multiple workbooks to current workbook in specified row number 0
Copying cells and formula from closed workbook to all sheets in open workbook 0
Importing all components in a folder 1
Excel 2011 Mac - Import Worksheets into a Single File 0
Create a list of all files in a folder 2

Back
Top