GrantTF Posted May 12, 2017 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
Neutro Posted May 12, 2017 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!
water Posted May 12, 2017 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
GrantTF Posted May 13, 2017 Author 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
water Posted May 13, 2017 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
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