F
Frank A Frugone
I have two documents: an excel spreadsheet and a word template.
I want to create a document from the word template that has fields for
a Start Date and End Date.
Each row in the excel spreadsheet corresponds to a single date.
Once I fill in the start date and the end date, I want a VBA script in
the word document to search the excel spreadsheet for the rows between
and including the Start Date and the End Date.
Then I want the VBA script to populate a word table in the word
document with the data from the rows found in the excel spreadsheet.
Finally, I want to have a field at the end of the word document that
totals the numbers in the last column of the word table.
How do I do it?
(Thanks in advance for any and all help rendered)
I want to create a document from the word template that has fields for
a Start Date and End Date.
Each row in the excel spreadsheet corresponds to a single date.
Once I fill in the start date and the end date, I want a VBA script in
the word document to search the excel spreadsheet for the rows between
and including the Start Date and the End Date.
Then I want the VBA script to populate a word table in the word
document with the data from the rows found in the excel spreadsheet.
Finally, I want to have a field at the end of the word document that
totals the numbers in the last column of the word table.
How do I do it?
(Thanks in advance for any and all help rendered)