Copy from Excel, then open and run a macro in Word template
Posted by Klaas on January 25, 2001 9:01 PM
I would like to put a button on a Excel(2000) sheet which if pushed will:
1) Copy the range F1 - F1460 (from the open sheet)
2) Open a Word template SSS.DOT which is stored in \Windows\Application Data\Microsoft\Templates\Graphology
3) Run the macro "SSS_Report", which is already in this Word template document.
What VB code do I use?