| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word mailmerge - Visual Basic experts please help!
That is probably because the Word Object library has not been referenced via
the Tools|References option in Access VBA. However, the original author may have avoided that deliberately because when you reference a library, the reference is to a specific version of Word. You can typically work around that using the following instead (you just don't see the autocomplete Help in the VBA editor that you would otherwise get) Dim objMMMD As Object -- Peter Jamieson http://tips.pjmsn.me.uk "Murray Muspratt-Rouse" wrote in message ...[color=blue][i] Thank you Doug for referring me to Peter Jamieson's advice. I have immediately run in to a problem - it does not like 'objMMMD As Word.Document' telling me 'User-defined type not defined' and suggesting that it might be in a properly registered object or type library. Did I misunderstand Peter's advice? Was I meant to change objMMMD to something else? Murray Doug Robbins - Word MVP;359552 Wrote: Actually, I did know what the code was doing, but did not understand why. However, I suggest that you follow the advice given by Peter Jamieson and use Dim objMMMD As Word.Document ' ' ' Set objMMMD = objApp.Documents.Open FileName:=strDocName, 'etc. ' ' ' ' then when you want to close the mail merge main document, instead of having to ' work out which window it is in, you can do objMMMD.Close SaveChanges:=False ' ' then Set objMMMD = Nothing -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Murray Muspratt-Rouse" wrote in message ... I agree with Doug about the code he does not understand - since I am not the original author of this code and do not speak VBA any way I have been struggling to find my way to add new function to the application. The merge document is selected by the user from an Access table in which the full path to the file is stored, so what the code that we cannot understand does is to strip off the path to the document from strDocName: - Dim intSplitName As Integer Dim intLength As Integer intLength = Len(strDocName) intSplitName = InStrRev(strDocName, "\", , vbTextCompare) strDocName = Right(strDocName, intLength - intSplitName) objApp.Windows(strDocName).Activate objApp.ActiveWindow.Close SaveChanges:=wdDoNotSaveChanges So perhaps what the last line does is to shut the new document, since the original merge document is displayed. I have tried commenting out this code but that only results in an error. I will try changing ActiveWindow in the last line to strDocName! Many thanks for your time and trouble Murray +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- Murray Muspratt-Rouse |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word mailmerge - Visual Basic experts please help!
My apologies- the syntax for the Open has to change to the "function" style
where the parameter list is surrounded by braces, e.g. Set objMMMD = objApp.Documents.Open(FileName:=strDocName) -- Peter Jamieson http://tips.pjmsn.me.uk "Murray Muspratt-Rouse" wrote in message ...[color=blue][i] I am very grateful to Peter for his advice - this morning I realised that I should have googled objMMMD. When I did that I found some of his postings on the web and started looking for Microsoft Office 12.0 Object Library, Trying to reference it showed it to be missing, so I tried to find its name and location. What I saw was cut off at c:\Program Files\Microsoft Office\Office 12\M - and I could not make the pop up any wider! I have tried Dim objMMMD As Object - the result was a compile error with a syntax error on Set objMMMD = objApp.Documents.Open FileName:=strDocName etc. I must locate the Object Library and regioster it, I think. Murray Peter Jamieson;359803 Wrote: That is probably because the Word Object library has not been referenced via the Tools|References option in Access VBA. However, the original author may have avoided that deliberately because when you reference a library, the reference is to a specific version of Word. You can typically work around that using the following instead (you just don't see the autocomplete Help in the VBA editor that you would otherwise get) Dim objMMMD As Object -- Peter Jamieson http://tips.pjmsn.me.uk "Murray Muspratt-Rouse" wrote in message ...- Thank you Doug for referring me to Peter Jamieson's advice. I have immediately run in to a problem - it does not like 'objMMMD As Word.Document' telling me 'User-defined type not defined' and suggesting that it might be in a properly registered object or type library. Did I misunderstand Peter's advice? Was I meant to change objMMMD to something else? Murray Doug Robbins - Word MVP;359552 Wrote:- Actually, I did know what the code was doing, but did not understand why. However, I suggest that you follow the advice given by Peter Jamieson and use Dim objMMMD As Word.Document ' ' ' Set objMMMD = objApp.Documents.Open FileName:=strDocName, 'etc. ' ' ' ' then when you want to close the mail merge main document, instead of having to ' work out which window it is in, you can do objMMMD.Close SaveChanges:=False ' ' then Set objMMMD = Nothing -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Murray Muspratt-Rouse" wrote in message ... I agree with Doug about the code he does not understand - since I am not the original author of this code and do not speak VBA any way I have been struggling to find my way to add new function to the application. The merge document is selected by the user from an Access table in which the full path to the file is stored, so what the code that we cannot understand does is to strip off the path to the document from strDocName: - Dim intSplitName As Integer Dim intLength As Integer intLength = Len(strDocName) intSplitName = InStrRev(strDocName, "\", , vbTextCompare) strDocName = Right(strDocName, intLength - intSplitName) objApp.Windows(strDocName).Activate objApp.ActiveWindow.Close SaveChanges:=wdDoNotSaveChanges So perhaps what the last line does is to shut the new document, since the original merge document is displayed. I have tried commenting out this code but that only results in an error. I will try changing ActiveWindow in the last line to strDocName! Many thanks for your time and trouble Murray - +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- Murray Muspratt-Rouse - +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- Murray Muspratt-Rouse |
|
#4
|
|||
|
|||
|
This time at execution the error message on "Dim objMMMD As Word.Document" was 'User-defined type not defined'. Does this mean I am missing something else? A 'type' library?
Murray Quote:
|
|
#5
|
|||
|
|||
|
I think I have overcome the Tools/References problem, but now I have another one: - I get an compile error message telling me that End of Statement was expected, highlighting FileName in the statement to which I have added 'Set objMMMD ='
Set objMMMD = objApp.Documents.Open FileName:=strDocName, ConfirmConversions:=False, _ ReadOnly:=False, AddToRecentFiles:=False _ , PasswordDocument:="", _ PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _ WritePasswordTemplate:="", XMLTransform:="" Murray Quote:
|
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word mailmerge - Visual Basic experts please help!
See Peter's previous message in which he says to use
Set objMMMD = objApp.Documents.Open (FileName: = strDocName, etc ) Probably all that you really need of that command is: Set objMMMD = objApp.Documents.Open (FileName: = strDocName, AddToRecentFiles:=False ) And that is on the assumption that you do not want the document to be added to the list of most recently used files. If that is not an issue, you can simply use Set objMMMD = obj.App.Documents.Open(strDocName) -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Murray Muspratt-Rouse" wrote in message ...[color=blue][i] I think I have overcome the Tools/References problem, but now I have another one: - I get an compile error message telling me that End of Statement was expected, highlighting FileName in the statement to which I have added 'Set objMMMD =' Set objMMMD = objApp.Documents.Open FileName:=strDocName, ConfirmConversions:=False, _ ReadOnly:=False, AddToRecentFiles:=False _ , PasswordDocument:="", _ PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _ WritePasswordTemplate:="", XMLTransform:="" Murray Peter Jamieson;359803 Wrote: That is probably because the Word Object library has not been referenced via the Tools|References option in Access VBA. However, the original author may have avoided that deliberately because when you reference a library, the reference is to a specific version of Word. You can typically work around that using the following instead (you just don't see the autocomplete Help in the VBA editor that you would otherwise get) Dim objMMMD As Object -- Peter Jamieson http://tips.pjmsn.me.uk "Murray Muspratt-Rouse" wrote in message ...- Thank you Doug for referring me to Peter Jamieson's advice. I have immediately run in to a problem - it does not like 'objMMMD As Word.Document' telling me 'User-defined type not defined' and suggesting that it might be in a properly registered object or type library. Did I misunderstand Peter's advice? Was I meant to change objMMMD to something else? Murray Doug Robbins - Word MVP;359552 Wrote:- Actually, I did know what the code was doing, but did not understand why. However, I suggest that you follow the advice given by Peter Jamieson and use Dim objMMMD As Word.Document ' ' ' Set objMMMD = objApp.Documents.Open FileName:=strDocName, 'etc. ' ' ' ' then when you want to close the mail merge main document, instead of having to ' work out which window it is in, you can do objMMMD.Close SaveChanges:=False ' ' then Set objMMMD = Nothing -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Murray Muspratt-Rouse" wrote in message ... I agree with Doug about the code he does not understand - since I am not the original author of this code and do not speak VBA any way I have been struggling to find my way to add new function to the application. The merge document is selected by the user from an Access table in which the full path to the file is stored, so what the code that we cannot understand does is to strip off the path to the document from strDocName: - Dim intSplitName As Integer Dim intLength As Integer intLength = Len(strDocName) intSplitName = InStrRev(strDocName, "\", , vbTextCompare) strDocName = Right(strDocName, intLength - intSplitName) objApp.Windows(strDocName).Activate objApp.ActiveWindow.Close SaveChanges:=wdDoNotSaveChanges So perhaps what the last line does is to shut the new document, since the original merge document is displayed. I have tried commenting out this code but that only results in an error. I will try changing ActiveWindow in the last line to strDocName! Many thanks for your time and trouble Murray - +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- Murray Muspratt-Rouse - +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- Murray Muspratt-Rouse |
|
#7
|
|||
|
|||
|
While thanking Peter and Doug for their advice I have to say that I have a major problem - I am not sure what objMMMD is. Does it stand for Mail Merge Main Document or something like that? If so is it meant to be used to identify the document set up with merge fields, so as to make it possible to close it without closing the result of the merge or whatever? If I am right then I think I understand what I must do to use it in the VBA code.
Also, because the References pop-up only shows me the first character of the module name (C:\Program Files\Common Files\Microsoft Office\OFFICE12\M) I do not whether one of the 12 dlls i can see is the right one! Murray [quote=Doug Robbins - Word MVP;360024]See Peter's previous message in which he says to use Set objMMMD = objApp.Documents.Open (FileName: = strDocName, etc ) Probably all that you really need of that command is: Set objMMMD = objApp.Documents.Open (FileName: = strDocName, AddToRecentFiles:=False ) And that is on the assumption that you do not want the document to be added to the list of most recently used files. If that is not an issue, you can simply use Set objMMMD = obj.App.Documents.Open(strDocName) -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Murray Muspratt-Rouse" wrote in message ...[color=blue][i] I think I have overcome the Tools/References problem, but now I have another one: - I get an compile error message telling me that End of Statement was expected, highlighting FileName in the statement to which I have added 'Set objMMMD =' Set objMMMD = objApp.Documents.Open FileName:=strDocName, ConfirmConversions:=False, _ ReadOnly:=False, AddToRecentFiles:=False _ , PasswordDocument:="", _ PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _ WritePasswordTemplate:="", XMLTransform:="" Murray Peter Jamieson;359803 Wrote:[color=green][i] That is probably because the Word Object library has not been referenced via the Tools|References option in Access VBA. However, the original author may have avoided that deliberately because when you reference a library, the reference is to a specific version of Word. You can typically work around that using the following instead (you just don't see the autocomplete Help in the VBA editor that you would otherwise get) Dim objMMMD As Object -- Peter Jamieson http://tips.pjmsn.me.uk "Murray Muspratt-Rouse" wrote in message ...- Thank you Doug for referring me to Peter Jamieson's advice. I have immediately run in to a problem - it does not like 'objMMMD As Word.Document' telling me 'User-defined type not defined' and suggesting that it might be in a properly registered object or type library. Did I misunderstand Peter's advice? Was I meant to change objMMMD to something else? Murray |
|
#8
|
|||
|
|||
|
I tried 'Dim objMMMD As Word.Document' again and got the error message "User-defined type not defined'. This is what makes me think I do not have the correct objMMMD module registered. I tried 'Dim objMMMD As Object' and the result was that the Mail Merge document was closed, but the display of the merge result only showed one document, instead of the 3 that I expected.
Murray [quote=Murray Muspratt-Rouse;360272]While thanking Peter and Doug for their advice I have to say that I have a major problem - I am not sure what objMMMD is. Does it stand for Mail Merge Main Document or something like that? If so is it meant to be used to identify the document set up with merge fields, so as to make it possible to close it without closing the result of the merge or whatever? If I am right then I think I understand what I must do to use it in the VBA code. Also, because the References pop-up only shows me the first character of the module name (C:\Program Files\Common Files\Microsoft Office\OFFICE12\M) I do not whether one of the 12 dlls i can see is the right one! Murray Quote:
|
|
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Word mailmerge - Visual Basic experts please help!
objMMMD is just a "label" assigned to a document object which by the command
Set objMMMD = objApp.Documents.Open (FileName: = strDocName, etc ) is being set to the document with the file name of strDocName, which I believe is your mailmerge main document. having done that, you can refer to that document by the label that is assigned to the object. There is nothing special about the MMMD other than it conveys some meaning as you have deduced to the use of a person reading the code You could just as well have used: Dim doc as Object Set doc = objApp.Documents.Open (FileName: = strDocName, etc ) but then doc does not convey as much intelligence to the user, other than it probably refers to a document, but which one. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Murray Muspratt-Rouse" wrote in message ...[color=blue][i] While thanking Peter and Doug for their advice I have to say that I have a major problem - I am not sure what objMMMD is. Does it stand for Mail Merge Main Document or something like that? If so is it meant to be used to identify the document set up with merge fields, so as to make it possible to close it without closing the result of the merge or whatever? If I am right then I think I understand what I must do to use it in the VBA code. Also, because the References pop-up only shows me the first character of the module name (C:\Program Files\Common Files\Microsoft Office\OFFICE12\M) I do not whether one of the 12 dlls i can see is the right one! Murray Doug Robbins - Word MVP;360024 Wrote:[color=green][i] See Peter's previous message in which he says to use Set objMMMD = objApp.Documents.Open (FileName: = strDocName, etc ) Probably all that you really need of that command is: Set objMMMD = objApp.Documents.Open (FileName: = strDocName, AddToRecentFiles:=False ) And that is on the assumption that you do not want the document to be added to the list of most recently used files. If that is not an issue, you can simply use Set objMMMD = obj.App.Documents.Open(strDocName) -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Murray Muspratt-Rouse" wrote in message ... I think I have overcome the Tools/References problem, but now I have another one: - I get an compile error message telling me that End of Statement was expected, highlighting FileName in the statement to which I have added 'Set objMMMD =' Set objMMMD = objApp.Documents.Open FileName:=strDocName, ConfirmConversions:=False, _ ReadOnly:=False, AddToRecentFiles:=False _ , PasswordDocument:="", _ PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _ WritePasswordTemplate:="", XMLTransform:="" Murray Peter Jamieson;359803 Wrote: That is probably because the Word Object library has not been referenced via the Tools|References option in Access VBA. However, the original author may have avoided that deliberately because when you reference a library, the reference is to a specific version of Word. You can typically work around that using the following instead (you just don't see the autocomplete Help in the VBA editor that you would otherwise get) Dim objMMMD As Object -- Peter Jamieson http://tips.pjmsn.me.uk "Murray Muspratt-Rouse" wrote in message ...- Thank you Doug for referring me to Peter Jamieson's advice. I have immediately run in to a problem - it does not like 'objMMMD As Word.Document' telling me 'User-defined type not defined' and suggesting that it might be in a properly registered object or type library. Did I misunderstand Peter's advice? Was I meant to change objMMMD to something else? Murray +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- Murray Muspratt-Rouse |
|
#10
|
|||
|
|||
|
Doug, thank you for confirming my guess! I have in fact used 'Dim objMMD As Object' as Peter recommended - the result of a merge that should have produced 3 letters was that I got only one. For the moment I intend to leave things as they are (without the objMMD code), so that users will finish the merge with the function provided by Word 2007, unless, of course, there is a solution for the problem I have described!
Murray Quote:
|
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word Visual Basic | Microsoft Word Help | |||
| Visual Basic through Word help | Microsoft Word Help | |||
| Problem with Visual Basic A in Word | Microsoft Word Help | |||
| MailMerge using Visual Basic ActiveX | Mailmerge | |||
| How do I stop Visual Basic Macros from word? | Microsoft Word Help | |||
Hybrid Mode
