How do I find the name of an excel file using excel macros?

Question

If I have the excel file open and want to switch between the file and another file while running a macro, how do I find the name of the file so that I can reference it later?

Answer 1

Your question is a little confusing. If you are wanting to reference the Excel file that is running the macro then all you have to do is use the term "ThisWorkbook". That will reference the file running the macro. So if you want find the name of the workbook that has the macro just enter this into the macro:

MsgBox ThisWorkbook.Name