any idea

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

Hi

Try recording a macro using a sample file. Then edit the macro and
replace the filename with Input("Please enter the file name").

That should get you started, assuming you have some basic coding under
your belt.

Hope I'm on the right track.

Simon