Guys, i need to automate a report creation for a nurse, i want her to click some option buttons on form ( it could be on word file) and after she finish she click submit, and she get the report in word file formatted well, what is the easiest method to do so, i tried the following:
Private Sub CommandButton1_Click()
Dim thyroid As String
If Normal.Value = True Then
thyroid = "Right and left thyroid lobes are normal in size."
Else
If enlarged.Value = True Then
thyroid = "Right and left thyroid lobes are enlarged."
End If
End If
End Sub
But i am not sure how to add the strings again in another file with accurate formatting,
is there any easier way you advise ? thanks.
Question
XP_2600
Guys, i need to automate a report creation for a nurse, i want her to click some option buttons on form ( it could be on word file) and after she finish she click submit, and she get the report in word file formatted well, what is the easiest method to do so, i tried the following:
Private Sub CommandButton1_Click() Dim thyroid As String If Normal.Value = True Then thyroid = "Right and left thyroid lobes are normal in size." Else If enlarged.Value = True Then thyroid = "Right and left thyroid lobes are enlarged." End If End If End Sub
But i am not sure how to add the strings again in another file with accurate formatting,
is there any easier way you advise ? thanks.
Link to comment
https://www.neowin.net/forum/topic/1322334-automate-report-creation/Share on other sites
0 answers to this question
Recommended Posts