Sorry for taking your time.Your original macro worsk beautifully.

Here are the mistakes I was making:
========================
1.) I was doing Set RefPage = Driver_sheet.xls.This is wrong.It shoul
be the name of the worksheet. Sheet1 in my case not the name of th
excel file.I am stupid.

2.) In the row5 , from where the description of the csv files is comin
there were a few names like velocity (km/hr). The symbol / i
unacceptable.It should be velocity(kmhr) instead.The script then work
beautifully

Thanks

excelgur

--
excelgur
-----------------------------------------------------------------------
excelguru's Profile: http://www.excelforum.com/member.php...nfo&userid=882
View this thread: http://www.excelforum.com/showthread.php?threadid=27363