I have a macro to open a file and I want to enter the file name from which
macro is run to a cell in opened file.

If I open abc.xls from file xyz.xls, then I want value of cell F2 in abc.xls
to be xyz