Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving User of Last Save
Hello,
I would like to the User of the Last Save displayed in Cell A10014. At this time I have the Author, which is incorrect. The below code is in "This Workbook" code module Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) [Billing!A1012] = ActiveWorkbook.BuiltinDocumentProperties("Subject" ).Value [Billing!A1013] = Now() [Billing!A1014] = ActiveWorkbook.Author End Sub Thanks Ruan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving User of Last Save
Ruan,
Try ActiveWorkbook.BuiltinDocumentProperties("Last Author") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Ruan" wrote in message ... Hello, I would like to the User of the Last Save displayed in Cell A10014. At this time I have the Author, which is incorrect. The below code is in "This Workbook" code module Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) [Billing!A1012] = ActiveWorkbook.BuiltinDocumentProperties("Subject" ).Value [Billing!A1013] = Now() [Billing!A1014] = ActiveWorkbook.Author End Sub Thanks Ruan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving User of Last Save
Thanks Bob.
I also stumbled across ActiveWorkbook.UserStatus which seems to work. Ruan "Bob Phillips" wrote in message ... Ruan, Try ActiveWorkbook.BuiltinDocumentProperties("Last Author") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Ruan" wrote in message ... Hello, I would like to the User of the Last Save displayed in Cell A10014. At this time I have the Author, which is incorrect. The below code is in "This Workbook" code module Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) [Billing!A1012] = ActiveWorkbook.BuiltinDocumentProperties("Subject" ).Value [Billing!A1013] = Now() [Billing!A1014] = ActiveWorkbook.Author End Sub Thanks Ruan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User defined file name on save | Excel Discussion (Misc queries) | |||
How do I share a workbook and allow user to save? | Excel Discussion (Misc queries) | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
User cannot save excel file in workbook | Excel Worksheet Functions | |||
Prompt user to save their file | Excel Programming |