Hi!

I want to insert the excel file name (using formula "=CELL("filename")") into cell A1 of sheet1 in multiple excel files
I'm not familiar with vba and I'd appreciate it if anybody could help me (if it could be done using macros of course )

Thanks