+ Reply to Thread
Results 1 to 3 of 3

Log username edited cell macro codes

  1. #1
    Registered User
    Join Date
    09-21-2009
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    Log username edited cell macro codes

    I have excel file(excel 2003). I want to log the information that record username opening my file and the text is edited.


    I search some codes in internet and i got this code...
    ........................................................................................
    Sub LogInformation(LogMessage As String)
    Const LogFileName As String = "C:\FOLDERNAME\TEXTFILE.LOG"
    Dim FileNum As Integer
    FileNum = FreeFile ' next file number
    Open LogFileName For Append As #FileNum ' creates the file if it doesn't exist
    Print #FileNum, LogMessage ' write information at the end of the text file
    Close #FileNum ' close the file
    End Sub
    .................................................................................
    Now, i have a problem when i execute this code. It does not work...
    Anyone can comment this code?
    I am just new in VBA codes....
    Please help me...

    Thank you
    Akou

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Log username edited cell macro codes

    Please wrap ur code within Code Tag...

    See forum rules

  3. #3
    Registered User
    Join Date
    09-21-2009
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Log username edited cell macro codes

    Anybody knows how to track changes in excel and log information like username in macro command?

    Need your help....

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1