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
Bookmarks