ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Write in word OLE object (https://www.excelbanter.com/excel-programming/428053-write-word-ole-object.html)

Jolene

Write in word OLE object
 
Hi

I created a new word doc in Excel by the following code:

"ActiveSheet.OLEObjects.Add ClassType:="Word.Document", _
Width:=437, Top:=177, Left:=241"

Now I want to put some text in that word doc (the user gives input into a
text box and it gets rewritten to the word doc). Does someone know how to do
that?

Thanks, it would be really great if you could help!


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com