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

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...b;EN-US;291304

3. OFFXP: Programming Resources for Visual Basic for Applications
http://support.microsoft.com/default...b;EN-US;305326

Regards,
Venkat.

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/de...us/modcore/htm
l/deovrWorkingWithMicrosoftExcelObjects.asp

Regards,
Venkat.

Thank you Vernkat, I'll try those.

Best regards,
Daniel


"Venkat Srinivasan.R" schrieb im Newsbeitrag
...

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/de...us/modcore/htm
l/deovrWorkingWithMicrosoftExcelObjects.asp

Regards,
Venkat.