View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M H M H is offline
external usenet poster
 
Posts: 28
Default Insert information to multiple similar files

A tab-delimited text file containing two columns of data, the first is
filename (in excel format) and the second is a corresponding data which
has to be inserted into the cell F2 in the sheet "Data Summary" of the
indicated file, is prepared. How to use macro to read that file and do
the insertion automatically?

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