How to find out the residing directory of the opened workbook using VBA code ?
Sub test()
MsgBox ActiveWorkbook.FullName, , "Full path of the active workbook"
End Sub
RBS
"Adrian" wrote in message
...
Hi ,
How do we find out the residing directory of the opened workbook using
VBA code ? The command "curDir" doesn't seem to work here ...
Thanks...
--
Regards,
Adrian
|