Help Please:( Import Excel Data To Word

Can't you just highlight the data in Excel and drag into the Word
document?

Or copy and paste?

Hans

I guess I need to do some macro programming...wud u help me on that?

its not a simple copy and paste special link thing coz i need to have a master file in excel where I can key in all datas and when I select the row or rather it should detect active row and will open in ms word document...

Okay, what I can come up with is this:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 26.02.2006 by h
'
channelNumber = Application.DDEInitiate(app:="WinWord", _
topic:="C:\SALES.DOC")
Set rangeToPoke = Worksheets("Sheet1").Range("A1:b1")
Application.DDEPoke channelNumber, "\StartOfDoc", rangeToPoke
Application.DDETerminate channelNumber

End Sub

However, whe I run the macro for the first time I get an info box
asking whether I want to start Winword. Click "yes".
Then I get an error message "type mismatch". Click "end".
>From there on the macro runs okay.

In the short time I had I couldn't find out what the reason is for the
error messasge.

Maybe a real expert reads this post and can suggest a solution.

If I have something new I will post it.

Good luck.

Hans