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.