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