feed data in multiple files without opening them

[M H]

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

 

[Tim Williams]

Why can't you open the files?

Tim

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

 

[M H]

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

 

[Ron de Bruin]

Try

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