S
spunkymuffmonkey
Greetings all,
I would love some advice/pointers on the following problem please!
Our users use a Word Document to record Contact Session details, each
contact session takes place on a different day and various detail about these
sessions are recorded in a table.
For every new session that takes place a new table within the document is
created. Within this document, I have previously created a macro which will
automatically create a new table and format it as with specific questions for
the end user to complete.
Within this automatically created table is an ActiveX DTpicker, by which the
user can select the date that the contact session took place.
My end users now want a process to be created whereby the tables are sorted
in chronological order by use of a Macro as the fear is that if one worker
fails to enter their contact session details in a timely fashion (i.e. before
the next session takes place) then the order can become out of order.
Although I have an idea of what I want to do I can’t work out the most
efficient way of doing this and hoped that someone cleverer or more
experienced might point to the right direction (i.e. the most efficient way
of achieving this goal.)
So far, whilst experimenting I have managed to feed all dates from all
tables in to a variable array, and my plan is to work out a way of comparing
these variables (i.e. put them in order) and then cut and paste the tables to
comply with this order.
Any advice or help or examples or words of encouragement will go a long way.
Thanks all!
I would love some advice/pointers on the following problem please!
Our users use a Word Document to record Contact Session details, each
contact session takes place on a different day and various detail about these
sessions are recorded in a table.
For every new session that takes place a new table within the document is
created. Within this document, I have previously created a macro which will
automatically create a new table and format it as with specific questions for
the end user to complete.
Within this automatically created table is an ActiveX DTpicker, by which the
user can select the date that the contact session took place.
My end users now want a process to be created whereby the tables are sorted
in chronological order by use of a Macro as the fear is that if one worker
fails to enter their contact session details in a timely fashion (i.e. before
the next session takes place) then the order can become out of order.
Although I have an idea of what I want to do I can’t work out the most
efficient way of doing this and hoped that someone cleverer or more
experienced might point to the right direction (i.e. the most efficient way
of achieving this goal.)
So far, whilst experimenting I have managed to feed all dates from all
tables in to a variable array, and my plan is to work out a way of comparing
these variables (i.e. put them in order) and then cut and paste the tables to
comply with this order.
Any advice or help or examples or words of encouragement will go a long way.
Thanks all!