| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing multiple text files into individual worksheets in workbook | Excel Programming | |||
| Importing all the .txt files of a folder in a same WB but in different WSheets | Excel Programming | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
| Importing multiple text files into single workbook | Excel Programming | |||
Linear Mode
