Help Please:( Import Excel Data To Word

[hennessey]

Hey guys,

I desperately need help on this...

How do I import a selected row to word document?

I have a deadline today and i've been trying to work this out since
yesterday... please any expert!

 

[flummi]

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

Or copy and paste?

Hans

 

[hennessey]

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

 

[flummi]

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