File name of file containing macro

[cogswel__cogs]

Hi I have a macro I wrote for coworkers. it sits in one file but work on both that file and another file. You have to be in the other file when firing, so it captures that file name easily. I then need to bring data from that file into the file with the macro. I do not want the user to be required to have the same file nme so is there a way to get the file name of the file that is running the macro?

 

[Fluff]

You can use ThisWorkbook

 

[cogswel__cogs]

Many thanks

 

[Fluff]

You're welcome & thanks for the feedback.