Insert filename.csv into the *.csv file [Closed]

Hi Trowa

I'm having 3000 files in *.csv format. I want to insert filename.csv into the *.csv file of 'A' column. Is it possible? I'm unable to find out the answer. In that file the data contains 3500 rows. I'm trying to figure out macro in this way. Open file > run macro > column should be inserted in 'A' Column > current open *.csv filename should be inserted in 'A' column > then close.
For Ex : My file name was ABC.csv
When i Open ABC.csv (this file name of ABC without extension) should be inserted in column A.

Can you help me out inthis regard.

Thanks & regards,


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!