Whoami

D

Dave the architect

I have a spreadsheet that has the whoami function in a
cell that enters the file name and path into the cell on
the spreadsheet. The function reads "whoami0" when I
select the cell. When I move the file to a new folder the
file name and path are not updating. What am I doing
wrong ?

Dave
 
C

Chip Pearson

Dave,

There is no built in WhoAmI function in Excel. I assume it is a
function written in VBA. Why it returns the incorrect information
depends on what the code is. There is a built in function that
will return the complete filename and sheet name:

=CELL("filename",A1)

Leave "filename" in the function as shown; don't change it to any
specific file name.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top