Syntax

2 Topics

'Calling' a function from within a Word document
I know this is probably really basic but this will be my first real dive into Word VBA, I am quite experienced in Excel VBA, though. I am having difficulty getting my head around how Word 'knows' that a 'block of text' is code, rather than just text of the document. As my first 'excursion', within Word VBA, I am seeking to split a phrase, when it is passed, through mail merge, from an Excel spreadsheet to a Word document. With apologies for i. the fact that my interface to this forum does not permit me to see all the proper formatting options for code and ii. the following is more of a 'storyboard' version of code, rather than the proper thing. The relevant Excel spreadsheet is used to support a group of mail merge letters and this 'issue' is only relevant to one letter, so I do not wish to redesign the spreadsheet; I would prefer to handle the 'issue' within Word, through VBA code. I will focus on two mail merge fields, within this question. The 2 mail merge fields are called, for the sake of simplicity here, i) Relative_Name and ii) Relative_Relationship. Relative_Relationship contains, for example, the value "Second Cousin Twice Removed of the Husband of my Second Cousin Once Removed", and, just to make up a name, Relative_Name contains "Walter Gerard Montague". Now when I simply include the fields in the other letters I simply type - Based on reviewing the online tree which has brought you to my attention, I can see that your tree includes «Relative_Name». Your relationship to me: «Relative_Relationship». and I would end up with a final merged text that reads - Based on reviewing the online tree, which has brought you to my attention, I can see that your tree includes Walter Gerard Montague. Your relationship to me: Second Cousin Twice Removed of the Husband of my Second Cousin Once Removed. On this occasion, though I want to split the contents of the field Relative_Relationship into two halves, through passing it to a VBA macro, so that I would end up with - Based on reviewing the online tree, which has brought you to my attention, I can see that your tree includes Walter Gerard Montague. Walter Gerard Montague is the Husband of my Second Cousin Once Removed and you are his Second Cousin Twice Removed. Now for the sake of the following let's call the VBA function, which I propose to write, Relationship_Phrase_Split. Now here is the nub of my question, how does Word know I am invoking the subroutine when I write, in the mail merge document, something that maybe looks like - Based on reviewing the online tree, which has brought you to my attention, I can see that your tree includes «Relative_Name». Relationship_Phrase_Split(«Relative_Relationship», maybe some other fields from the Excel spreadsheet to control how the splitting is done, e.g. «Gender»). I have only italicised, in the above, just to highlight where I am needing assistance to understand how to cause Word to process the code. I am not asking for help on the split function, only the correct syntax for calling it, please. I have made the document a .docm extension. With thanks in anticipation. Philip Bendigo, Vioctoria
Solved
PMHunt1955
Jul 28, 2019 Place Word
4.1KViews
1like
2Comments
Vlookup Syntax Within Formatted Table / Structured Reference
AFternoon all, need help on syntax with Vlookups across two separate tables within the same workbook - text of my formula below - please let me know if any further info is needed: For referece: the vlookup is on a table named "Etran" (within a sheet labelled "Etran"), the data i am trying to pull back is on a table labelled "Assembly" (on a sheet named Assembly). Can anyone see what is causing errors with this syntax below? =VLOOKUP([@[Unit + Pt]],Assembly[@[Unit + Pt]]:Assembly[@[Iplan_ID]],30,0) Thanks! Joe
JoeCavasin
Dec 04, 2018 Place Excel
4KViews
0likes
1Comment