Hi
I have created a multi-page form with textboxes, combobox etc and i am trying to find the best way to populate the information into a word document, i need to be able to populate onto a page and the text needs to appear in the next available line or row if i use a table; i have done this in excel and it works well but as this needs to be a professional looking report i thought it would be best in word.



hope someone can help
thanks

Hi Molesy
Would you not be better formatting the document in Excel and then embedding the main body in a Word document. That way you have the best of both worlds.
Hope this helps.
Tony

Hi
Thats the best bit of advice i have had, the problem is i do not know where to start with that one, i created this report in excel to start with but it doesnt look that good, if i could embed the report in word could you please advise how this is done.
thanks

Hi Molesy
Can you let me have a copy of your template leaving out any sensitive stuff and I will format it in Excel so it looks like a Word document then provide you with instructions on embedding it into a Word document.
Tony

Hi Tony

Thanks for your reply; I am nearly there, i got some code and changed it slightly to embed excel with the use of button control using vba, the only problem i have is when i open the template BSxltm it outomatically renames the file BS1.xltm and for some reason the text does not embed into a word document, it opens a new document but no text, if i was to close the BS.xltm1 book the BSxltm is behind it and works perfectly can you shed some light on this please