Posted to microsoft.public.excel.programming

Ruan[_3_]

external usenet poster

Posts: 33

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User defined file name on save	Jim G	Excel Discussion (Misc queries)	11	October 30th 06 01:29 AM
How do I share a workbook and allow user to save?	Alicia	Excel Discussion (Misc queries)	0	October 13th 06 03:47 PM
save prompt for user exit, but no save prompt for batch import?	lpj	Excel Discussion (Misc queries)	1	February 25th 06 02:08 AM
User cannot save excel file in workbook	Justin@Martin	Excel Worksheet Functions	0	May 16th 05 01:52 PM
Prompt user to save their file	Sharon[_5_]	Excel Programming	4	September 29th 03 09:44 PM

All times are GMT +1. The time now is 09:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us