• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 86
  • Last Modified:

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
0
frugalmule
Asked:
frugalmule
1 Solution
 
GrahamSkanRetiredCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now