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