Hi All,
When I was browsing mr.excel.com I learnt how to convert excel data to a template in word.
Below is the link where I have saved my Excel file with the macro.
http://www.box.net/shared/0qmvopqouf
When you run FINAL macro it saves word document with the template (with the data in Formated Sheet).
As Specified in the macro the word document saves in the name as "File and the sequential number".
But I need the documents to be named with the data in Column H of the Formatted Data Sheet sequentially. Also the data in the word document are not formatted properly.
The word document looks like this after the macro.
http://www.box.net/shared/a2bpvdhesu
But I need the Word to show my data in the format below.
http://www.box.net/shared/8hblc2k9qo
Is there a possibility to do this?
Your help is much appreciated
When I was browsing mr.excel.com I learnt how to convert excel data to a template in word.
Below is the link where I have saved my Excel file with the macro.
http://www.box.net/shared/0qmvopqouf
When you run FINAL macro it saves word document with the template (with the data in Formated Sheet).
As Specified in the macro the word document saves in the name as "File and the sequential number".
But I need the documents to be named with the data in Column H of the Formatted Data Sheet sequentially. Also the data in the word document are not formatted properly.
The word document looks like this after the macro.
http://www.box.net/shared/a2bpvdhesu
But I need the Word to show my data in the format below.
http://www.box.net/shared/8hblc2k9qo
Is there a possibility to do this?
Your help is much appreciated
