Thread: Importing all files in a folder to excel workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kmcosta kmcosta is offline
external usenet poster
  
Posts: 2
Default 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.

Reply With QuoteReply With Quote