ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Command (https://www.excelbanter.com/excel-discussion-misc-queries/58157-macro-command.html)

VickyC

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


exceluserforeman

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