How could I be able to open different files (excel files) automatically by
just typing the name of the files. Is there any macro or ..............
function could do this??
What it is, I will be generating different *.csv files and I want them to be
imported to excel format

I may be misunderstanding you, but if you double-click a csv file in
Windows explorer it will open in Excel.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup