Data Copy & File Save As in a Sequence
Posted by Mark on October 16, 2001 8:45 AM
can anyone help please...
...generaly I have got 2 files
one (xxxx.xls) contains the
reference data (i.e. single
column of data)
each one of the cells
from file xxxx.xls
needs to be copied in sequence to
a particular cell in
file two (yyyy.xls) as well
as perform a Save As Operation
with the filename equal to the value of
cell copied. Once done, next value from in sequence
(from file xxxx.xls is read and treated same as above)
hope the above makes sense...
Many thanks for your help...