Dear Excel Experts,

Can any one help me how do I take the path of the opened file in a cell.

For example :
Opened file name : time sheet.xls
Path / Directory : D:\my office data\months\april06

I want the path / directory information in a cell say a1 (ie. D:\my office data\months\april06)


Thanx in advance
C N Prasad
India