Extraction from mores files

  • Thread starter Thread starter JP forum
  • Start date Start date
J

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
 
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
Click to expand...

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.
 
Back
Top