I have the string that includes path and filename:

C:\Documents and Settings\Folder1\Folder2\....\filename

How can I easily load only the filename to the variable f_name?

What you've got there is ThisWorkbook.FullName. To get just the file name
use ThisWorkbook.Name and assign that to f_name.