Export Word VBA Variables to Excel and append

[Dandelion026]

We have a Word VBA macro that runs daily.
This macro does an number of counts and the value of these counts are shown
in a messagebox and printed in a new worddocument.

I would like to start an administration of these counts

So I want to export the value of the variables in to an Excel Sheet, add the
run date and time and place the different vairables in a new row

This excel sheet should be update daily with the new row of values.

Can anyone please help me in setting this up?

thanx in advance!
Jaap

 

[Doug Robbins - Word MVP]

See the article "Control Excel from Word" at:

http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP