Setting Number of Words

[Wakey1]

Hi

I am trying in export data to word and have used the following. This example below is to export the first line of an address (VARADD1). However it appears to generate and open the word template but is still not inserting the address line into the word template from excel.

Someone has told me I need to set the 'NumberOfWords' to make this work. I have tried to make something work (area highlighted red) but to no avail. The error message also states 'Object Required'.

Any help would be appreciated.

Please Login or Register  to view this content.

[Leith Ross]

Hello Wakey1,

Provided that VARADD1 returns a string, this macro should work for you.

Please Login or Register  to view this content.

Sincerely,
Leith Ross