Wanna make quick notes to yourself about what you do during the day? Kind of a log thing? Lifehacker has a tidy little VB script (sorry, Mac cultists) that'll do exactly that for you.
I've updated it a tad to use my preferred date and time format (kinda Unixey), enclose the date in brackets, and separate the date/time from the description with a tab character to make it easier to import into a spreadsheet, should the need arise. (I would have posted it on the lifehacker comments, but you need an invite.)
'----------------------------------------------------------- ' QuickLogger v.0.1a ' Appends the date and a line of text to a file. ' Based on code written by Joshua Fitzgerald, 7/2005. ' Modified by Gina Trapani, 7/2006. ' Modified by thatbaldguy, 7/2006 (unauthorized). '----------------------------------------------------------- Option Explicit Dim filename filename = "C:\logs\worklog.txt" Dim text text = InputBox("Add to "&filename&":", "Quick Logger") if text <> "" then WriteToFile(text) end if Sub WriteToFile(text) Dim fso Dim textFile Set fso = CreateObject("Scripting.FileSystemObject") Set textFile = fso.OpenTextFile(filename, 8, True) textFile.WriteLine "[" & DatePart("yyyy", Now) & "-" _ & Right("0" & DatePart("m", Now), 2) & "-" _ & Right("0" & DatePart("d", Now), 2) & " " _ & FormatDateTime(Now, 3) & "]" & Chr(9) & text textFile.Close End Sub
Log on, my friend.
No comments:
Post a Comment