Auto Text
 

How do I have Excel enter the path of a workbook like the auto text function
does in Wrod?

Howard

Assuming you want the path and name in a cell you must enter a formula in that
cell.

See Bob Phillips' site for various combinations.

http://www.xldynamic.com/source/xld.xlFAQ0002.html

OR use a macro assigned to a button or shortcut key.

Sub PathInCell()
ActiveCell.Value = ActiveWorkbook.FullName
End Sub


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 12:13:06 -0800, Howard
wrote:

How do I have Excel enter the path of a workbook like the auto text function
does in Wrod?