View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default feed data in multiple files without opening them

Why can't you open the files?

Tim


"M H" wrote in message
...
An Excel file containing two columns of information, first column is
a
list of .xls filenames (the list is created in DOS: dir -b *.xls
filelist.txt) and the second column is a list of corresponding
strings

that need to be fitted into the F2 cell of the corresponding .xls
file.
I would like to seek for help for accomplish it using VBA, and
without
opening the list of .xls files.

*** Sent via Developersdex http://www.developersdex.com ***