Public Function getfilepath()
getfilepath = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
End Function
create the the above function and call from your cell by using
formulae =getfilepath()
--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile:
http://www.excelforum.com/member.php...o&userid=16271
View this thread:
http://www.excelforum.com/showthread...hreadid=313846