aliaslamy2k
Active Member
- Joined
- Sep 15, 2009
- Messages
- 416
- Office Version
- 2019
- Platform
- Windows
Dear Colleagues,
I need a code which created a log file when any record is updated in excel, I found one similar code, but i dont know how to modify.
Private Sub EnterButton_Click()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Dim PWord As String<o></o>
PWord = "Password"<o></o>
<o></o>
Open "C:\Password Log.txt" For Append Access Write As #1<o></o>
Print #1, Now & "- Password Attempt"<o></o>
Print #1, Application.UserName<o></o>
The log file looks this
11/21/2009 4:14:12 AM- Password attempt
02963
11/21/2009 4:17:21 AM- Password attempt
02963
But I need to change it as record updated.
Rgds,
AB
I need a code which created a log file when any record is updated in excel, I found one similar code, but i dont know how to modify.
Private Sub EnterButton_Click()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Dim PWord As String<o></o>
PWord = "Password"<o></o>
<o></o>
Open "C:\Password Log.txt" For Append Access Write As #1<o></o>
Print #1, Now & "- Password Attempt"<o></o>
Print #1, Application.UserName<o></o>
The log file looks this
11/21/2009 4:14:12 AM- Password attempt
02963
11/21/2009 4:17:21 AM- Password attempt
02963
But I need to change it as record updated.
Rgds,
AB