How to copy data from excel to Word? Thanks for your help!!

  • Thread starter Daniel Walzenbach
  • Start date
D

Daniel Walzenbach

Hi,



Does somebody know how I can copy data from Excel (XP) to Word (XP) using VBA, e.g. copy a selected range of cells from an already opened Excel worksheet, open a new Work file and paste the content into the newly opened Word file? Also, if possible, I want to know how to copy a diagram from excel to word and how to position it.



Thank you a lot in advance! I appreciate your help!

Daniel Walzenbach
 
V

Venkat Srinivasan.R

This posting is provided "AS IS" with no warranties, and confers no rights

Hi ,

I found the following KB articles . Hope it helps

1. How to Select Cells/Ranges Using Visual Basic Procedures in Excel :
http://support.microsoft.com/default.aspx?kbid=291308

2. How to Select Ranges Using Visual Basic for Applications (Novice
Examples)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;291304

3. OFFXP: Programming Resources for Visual Basic for Applications
http://support.microsoft.com/default.aspx?scid=kb;EN-US;305326

Regards,
Venkat.
 
Top