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

[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

 

[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.

 

[Venkat Srinivasan.R]

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

Hi ,

Also see this link

Microsoft Office XP Developer :
Working with Microsoft Excel Objects :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/htm
l/deovrWorkingWithMicrosoftExcelObjects.asp

Regards,
Venkat.

 

[Daniel Walzenbach]

Thank you Vernkat, I'll try those.

Best regards,
Daniel