Inserting the filename of a file i have opened

[rhino4eva]

I know this is a little strange but.......
I recorded a macro to input a txt file into a worksheet
it only comprises of two columns starting in A1
I would like to be able to insert the filename (automatically) that I have used into c1
not bothered about the path just the name.
I have used the formula Cell=("filename")but that's just the new sheet not the one that was the input

Any help would be appreciated

 

[Scott T]

Please post the code you have.