Cell coments into Word

Hello

I have been fiddling around with it but i rather ask the pros.

I have a work sheet which i will attach to this post.
It list the dates and some names. For each date and name there will be
a place added including a comment. I need to have a button that starts the script. Then the date has to be check or searched for in the column. Once the collum fitting to todays date is found every row has to be checked and the cell
comments have to be saved into word.

What i already got:
1. there are two scripts in the spread sheet. One that copies all the comments in the sheet into a word file using a template
2. the second sheet has a different script (i will merge them as soon as they all go ok)
todays date is copied into a variable
the script finds the correct column.
It does not save the comments in the selected column.
The 'row' search does not work properly and thus
all the cell comments are printed

Can someone edit my script and tell me what changes I have to make? Thanks.

Please Login or Register  to view this content.