copy data from Excel to Word

[zangel]

Hi

I need some help

I use to have an Excel form to do this. Now I have to do it with Word.

I created my form in Word.

I need help to write the macro.
1- I need to open an Excel file called (database.xls)
2- I want Excel to go to last row and copy the number that is in th
last row.
3- Then, I need to paste this number into Word.

Can this be done

 

[Howard Kaikow]

One approach is to create an Excel object within the Word macro.
Then, via the Excel object, you likely can use most of the code from the
Excel macro.

 

[Doug Robbins - Word MVP]

See the article “Control Excel from Word” at:

http://word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP