How do I have Excel enter the path of a workbook like the auto text function does in Wrod?
H Howard Mar 16, 2005 #1 How do I have Excel enter the path of a workbook like the auto text function does in Wrod?
G Gord Dibben Mar 16, 2005 #2 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
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
