Excel Name

Hi everyone,

How do I tell, with VBA, which file name i'm working in?

so, if the file i'm working on is named "Adi's Excel Spreadsheet", how do i put that value into a variable to use in a function later?

thanx

Thaks everyone anyway. I believe i figured it out.

for anyone that is interested the code is:

ActiveWorkbook.Name

that should tell you the name of the file you're working on.