GrantTF Posted May 12, 2017 Share Posted May 12, 2017 Hi All Trying to populate a word template with data from another application, I have got my content in the paste buffer. I have managed to find some text and then paste with the following Local $oRangeFound $oRangeFound = _Word_DocFind($oDoc, "SomeSearchString") If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Word UDF: _Word_DocFind Example", _ "Error locating the specified text in the document." & @CRLF & "@error = " & @error & ", @extended = " & @extended) $oRangeFound.paste This works fine but I really wanted to do it with a bookmark, so I could put a number of bookmarks in the document template and repeat the process. Overwriting the bookmarks is ok But I can seem to get the paste to work for the bookmark. any advice would be much-appreciated cheers Grant Link to comment Share on other sites More sharing options...
Neutro Posted May 12, 2017 Share Posted May 12, 2017 (edited) Hi GrantTF, Are you using an english translator? Your post is hard to understand. If yes, then maybe consider posting in your native language. Regards. Edited May 12, 2017 by Neutro Identify active network connections and change DNS server - Easily export Windows network settings Clean temporary files from Windows users profiles directories - List Active Directory Groups members Export content of an Outlook mailbox to a PST file - File patch manager - IRC chat connect example Thanks again for your help Water! Link to comment Share on other sites More sharing options...
water Posted May 12, 2017 Share Posted May 12, 2017 There is a bookmarks collection available in Words objct model. You could try to select a bookmark and replace it with your text. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
GrantTF Posted May 13, 2017 Author Share Posted May 13, 2017 11 hours ago, GrantTF said: I thought I had written it in English, must be my bad grammar -will try and rephrase I have a word document template that I would like to populate with data from another application, I have the data from the other application in my clipboard and I want to paste it at a bookmark. My code below, works by searching for a phrase and pasting, but I can't get it to work for a bookmark Local $sDocument = @ScriptDir & "\Template.docx" Local $oDoc = _Word_DocOpen($oWord, $sDocument, Default, Default, True) ; move there Local $oRangeFound $oRangeFound = _Word_DocFind($oDoc, "stringToReplace") If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Word UDF: _Word_DocFind Example", _ "Error locating the specified text in the document." & @CRLF & "@error = " & @error & ", @extended = " & @extended) $oRangeFound.paste MsgBox($MB_SYSTEMMODAL, "Word UDF: _Word_DocFind Example", _ "string 'stringToReplace' replaced with clibboard.") So how do I select a bookmark and paste the clipboard, instead of doing the find Hopefully, that's easier to understand Quote Link to comment Share on other sites More sharing options...
water Posted May 13, 2017 Share Posted May 13, 2017 As I described above. Loop through the bookmarks collection, select the one you need and then paste the data. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now