Excel VBA insert cell value into Word bookmark without opening WQord doc

Hi

Is it possible to in Excel VBA to insert cell value into Word bookmark without opening  the Word doc?
If so, what code would I use?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Rgonzo1971Commented:
HI,

pls try

Sub Macro()
strPath = "C:\"
FileToOpen = "myFile.docx"

On Error Resume Next
Set wrdApp = GetObject(, "Word.Application")
If wrdApp Is Nothing Then
    Set wrdApp = CreateObject("Word.Application")
    Set wrdDoc = wrdApp.Documents.Open(strPath & FileToOpen)
Else
    Set wrdDoc = wrdApp.Documents(FileToOpen)
    If wrdDoc Is Nothing Then
        Set wrdDoc = wrdApp.Documents.Open(strPath & FileToOpen)
    End If
End If
On Error GoTo 0

With wrdDoc
    'YourCode
End With

Set wrdDoc = Nothing
Set wrdApp = Nothing

End Sub

Open in new window

Regards
0
 
Rgonzo1971Commented:
Hi,

No,

What are you trying to do?

Regards
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
I have many different word docs that i am trying to copy data from one spreadsheet into so it would be best if i didnt have to open all the word docs at once. Maybe i should just check if the doc is open and not reopen it every time. How would I do this? Thanks
0
 
FarWestCommented:
if this is repeated job (and not only for one time) and you have word 2010 or later (I don't know about 2007) the you can save those documents as word XML, and alter it programmatically using xml or regular file read/write operations
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great feedback. Thank you both
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.