I need to be able to click a button on a form in Excel which then selects a variable size range of data and copies it into a Word document.
Selecting range is easy enough but I need to copy this, then open a Word document and paste the data into it.
It must be done through code. Physically copying and pasteing is not what I need.
There was a thread on here which started this but then stopped before the answer appeared.
Thanks guys
Selecting range is easy enough but I need to copy this, then open a Word document and paste the data into it.
It must be done through code. Physically copying and pasteing is not what I need.
There was a thread on here which started this but then stopped before the answer appeared.
Thanks guys