feed data in multiple files without opening them
 

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 ***

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 ***

feed data in multiple files without opening them
 

Hi Tim,
The list of files would be 150, and I remember that the feeding could
be done without keeping opening and closing the files by stating the
complete path of the files, but I just don't know the proper syntax to
do it. Please help.


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

feed data in multiple files without opening them
 

Try

http://www.rondebruin.nl/copy4.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"M H" wrote in message ...
Hi Tim,
The list of files would be 150, and I remember that the feeding could
be done without keeping opening and closing the files by stating the
complete path of the files, but I just don't know the proper syntax to
do it. Please help.


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