Extraction from mores files

[JP forum]

Dear all
From 234 files i need to collect data from specific cells, and add
into a new spreadsheet(not summarized), so all the data is located
underneath eachother - how can that be done ?
Info:
- The filenames has no pattern
- Some cells can be empty

Kind regards
Lars Broberg

 

[Nayab]

Dear all
From 234 files i need to collect data from specific cells, and add
into a new spreadsheet(not summarized), so all the data is located
underneath eachother - how can that be done ?
Info:
- The filenames has no pattern
- Some cells can be empty

Kind regards
Lars Broberg

I believe all the files are under one directory. In this case u can
create a filesystem object as
Set fs = CreateObject("scripting.filesystemobject")
then u can get the file name of all the files in this directory using:
Set ParentFld = fs.GetFolder (SourcePath)
Set fileList = ParentFld.Files
Now for each one in the fileList, u can do the processing u want.

 

[Ron de Bruin]

Start here

Maybe you like the add-in
http://www.rondebruin.nl/copy3.htm