Hi Murray,
afaik there is no possibility to export data automatically
into a .doc file because macros just give commands to
excel... you could use a macro to open a word .doc and
paste the data by giving him the keyboard commands... but
I would not prefer that...
If it helps you, you could at least use a macro to copy
the cells you want - so you just need to open word and
press ctrl+v ...
therefor you can use range("cell1","cell2").copy
Best
Markus
-----Original Message-----
Hi all,
I work with Spreadsheets almost daily and evertime I
finish one I export certain cells to word. I do this by
cutting from Excel and pasting in Word. i can not use the
linked spreadsheet because the word document is usually
sent to the client as an offer.
I was hoping someone could either show me some code to
export automatically from Excel to word or a good site to
see if I can learn how it is done.
Thanks in advance
Murray
.