Access the File Name?

[dguenther]

Hi,

I have a column of text like the following

No. CV-89-0328-PR
No. CV-90-0356-AP
No. CV-89-0366-PR
No. CV-89-0265-PR
No. CR-88-0134-AP
No. CV-89-0303-SA
No. CR-87-0317-AP


It is going to be in a file called "Alabama-1995".

I would like to have a macro that makes that that column:

Alabama-1995-No. CV-89-0328-PR
Alabama-1995-No. CV-90-0356-AP
Alabama-1995-No. CV-89-0366-PR
Alabama-1995-No. CV-89-0265-PR
Alabama-1995-No. CR-88-0134-AP
Alabama-1995-No. CV-89-0303-SA
Alabama-1995-No. CR-87-0317-AP


I feel like it would be simple enough, but I can't figure out how to access the file's name.

Thanks,

Danny

 

[BarCodeWiz]

How about:
Application.ActiveWorkbook.FullName

 

[dguenther]

And if anyone else is looking for this:

http://www.exceltip.com/st/Cell_Function_Returns_Sheet_Name,_Workbook_Name_and_Path/180.html

is a good article.