B bugntl Nov 3, 2008 #1 Is it possible to find the last user who modified my file ? Not with VB but with somekind of function ?
Is it possible to find the last user who modified my file ? Not with VB but with somekind of function ?
G Gary''s Student Nov 3, 2008 #2 Without using VBA code, you could instruct openers to record their names in a specific cell in a specific worksheet. or Right the file icon and select Properties > Summary > Advanced and read the last modified field.
Without using VBA code, you could instruct openers to record their names in a specific cell in a specific worksheet. or Right the file icon and select Properties > Summary > Advanced and read the last modified field.
D dbKemp Nov 3, 2008 #3 Is it possible to find the last user who modified my file ? Not with VB but with somekind of function ? Click to expand... This should do it from code: ActiveWorkbook.BuiltinDocumentProperties("Last Author")
Is it possible to find the last user who modified my file ? Not with VB but with somekind of function ? Click to expand... This should do it from code: ActiveWorkbook.BuiltinDocumentProperties("Last Author")