I would like a Macro/VB routine that will read the particular Excel spreadsheet column and copy the price from each roll to a particular text file (one for each stock). Can this be done?

Excel Format
col 1 col 2
row 1 2/18/2005 9.11 (daily price of stock 1)
row 2 2/18/2005 13.88 (daily price of stock 2)
row 3 2/18/2005 12.05 (daily price of stock 3)
etc.


Format of Text file:

"02/18/2005",132.80,0

Each day's price for each stock will be in the same column each day with each roll representing a different stock. Also, I need to copy the "xx/xx/xxxx",price,0 to each test file. The current date will be in an adjacent column. (again, same column each day).