Determining the full path and filename of an active workbook
 

Is there any way to determine the full path and filename of the active
workbook? I'm writing a macro that creates and saves files, and I'd like it
to reference the full path of the file so that I can use the same program to
open and view the files afterwards. Any suggestions?

Determining the full path and filename of an active workbook
 

thisworkbook.path

should do it



--


Gary


"Aaron Dyck" wrote in message
...
Is there any way to determine the full path and filename of the active
workbook? I'm writing a macro that creates and saves files, and I'd like it
to reference the full path of the file so that I can use the same program to
open and view the files afterwards. Any suggestions?