Work log - primary emphasis, FAST

Attached is a notbook.  My goal is to make a few basic things happen

1. new entries happen from the top instead of the bottom.  
2. date/time should be automatic
3. no more than one line could be entered per item.

Assistance is greatly appreciated
Lined-Paper.docx
frugalmuleAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
GrahamSkanConnect With a Mentor RetiredCommented:
Your document  has a table. The header row has two columns, but the rest of the table has only one, so it isn't clear where you want the date to go, but let's start with this;
Sub AddNote(strText As String)
    Dim tbl As Table
    Dim rw As Row
    
    Set tbl = ActiveDocument.Tables(1)
    Set rw = tbl.Rows.Add(tbl.Rows(2))
    rw.Cells(1).Range.Text = Date & " " & strText
End Sub

Open in new window

0
 
frugalmuleAuthor Commented:
This would have worked, but I found an even better solution by incorporating it into a spreadsheet that already exists in our process.
0
All Courses

From novice to tech pro — start learning today.