![]() |
Macro Command
Good Morning, I have created a bill Template in Excel and I need this to print one copy on Headed and 2 copies on Plain. I seem to be having a lot of problems with this. So I am now trying a macro to select all and copy open a word document paste the bill into the word doc and then run the LetterCopy Marco from Word and then go back to excel? I seem to be 98% there. Although I am having problems with getting it to paste. It is selcting all/ copying opening word fine. Please can anyone advise. I would really appreciate it.... ? Thanks, -- VickyC ------------------------------------------------------------------------ VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391 View this thread: http://www.excelforum.com/showthread...hreadid=489764 |
Macro Command
maybe from Word you can insert the spreadsheet
"VickyC" wrote: Good Morning, I have created a bill Template in Excel and I need this to print one copy on Headed and 2 copies on Plain. I seem to be having a lot of problems with this. So I am now trying a macro to select all and copy open a word document paste the bill into the word doc and then run the LetterCopy Marco from Word and then go back to excel? I seem to be 98% there. Although I am having problems with getting it to paste. It is selcting all/ copying opening word fine. Please can anyone advise. I would really appreciate it.... ? Thanks, -- VickyC ------------------------------------------------------------------------ VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391 View this thread: http://www.excelforum.com/showthread...hreadid=489764 |
All times are GMT +1. The time now is 01:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com