Copy excel range and paste special picture (metafile) into existing word dot VBA

I don't know why I cannot find this answer. I know I've found it before. My apolgies.

I've created a data worksheet Sheet1.
Sheet2 contains a form that is automatically populated with data when I enter an item code (that I have created). Its a mass of vlookups and index array formulas. It's pretty neat... Anyhow. Once the user enters thier item tag into the excel spreadsheet2 the form is populated with data and ready to save & email. Many people receive these emails and some do not want excel files because they prefer word files... So what I'd like to do is have a button at the bottom of the "form" in sheet2 that will:
1) Copy cells ("A1:G30")
2) Open a specific word template "template 123.dot"
3) Paste special picture (metafile)
4) Save that word doc - naming the file the text found in 3 of the cells of sheet2 (a1, a2 & a3), into a specific folder ("...desktop\my folder")

I'm using excel 2003. At the beginning of this whole process I had the button working and only had to figure out how to paste special and then I was going to start work on save as file name. I got off on too many tangents and basically lost everything that worked...
If anyone can help I'd appreciate it. Cheers,
Mark

Try something like this. Set the location of the template to suit.

Please Login or Register  to view this content.

Based on your last post it seems that you are satisfied with the solution(s) you can mark your thread as "SOLVED".

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.