refering to file location
Posted by henry collet on February 08, 2002 8:05 AM
How can I obtain the path to the folder of the current workbook. I can use the PATH function to find excel, and the FULLNAME function to get the fullname of the workbook, but how do I get its path.
TIA,
Henry
Posted by faster on February 08, 2002 8:50 AM
This should work.
MsgBox ActiveWorkbook.FullName
Posted by Ivan F Moala on February 08, 2002 10:37 AM
MsgBox ActiveWorkbook.Path (N/T)
