Home > Time Error > Visual Basic Error 5941

Visual Basic Error 5941


Michael S. Start a new thread here 5380945 Related Discussions Automate Mail Merge help with Code in access 2000 Runtime Error 5941 "The requested member of the collection does not exist" Accessing a Here is my code Sub KitLabels() ' ' KitLabels Macro ' Macro recorded 9/28/2009 by MVP ' ActiveDocument.MailMerge.DataSource.QueryString = _ "SELECT * FROM `'Credit Card Data$'` WHERE `Kit 1` = '12/15/13' Would love this to work as I can not have both controls and legacy form controls in same document - good on you microsoft!

All rights reserved. Click Here to join Tek-Tips and talk with other members! Produce Dürer's magic square Given that ice is less dense than water, why doesn't it sit completely atop water (rather than slightly submerged)? Privacy statement Community Resources O365 Technical Network MSDN Forums UserVoice Stack Overflow Follow Us Twitter Facebook Office Dev Blog © 2016 Microsoft United States - English Terms of Use Trademarks Privacy

Vba Error 4605

The most likely reason that the Windows("Kit Label Framework.docx").Activate fails is that, although the file is already open, there's no window created for it. Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Sub PopulateBookingForm() Dim SourceTemplateName As String, DestTemplateName As String ' Set Method Statement Name SourceTemplateName = ActiveDocument.Name ' Open Heavy Cranes ICO Booking Form ChangeFileOpenDirectory "\\SERVERSHARE\HCD\HCD General\Templates\" Documents.Open FileName:= _ "\\SERVERSHARE\HCD\HCD Woodabyna wrote: I have followed Greg's instructions for check boxes on but when I double click on the box it gives me the run time error.

Another word for something which updates itself automatically Trick or Treating in Trutham-And-Ly Are basis vectors imaginary in special relativity? Should the sole user of a *nix system have two accounts? For example, the following deletes the AutoCorrect entry named "acheive" if it is part of the AutoCorrectEntries collection. Runtime Error 4248 Word 2010 No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers

I've tried different variations on the code but keep receiving errors. Run Time Error 5941 The Requested Member Of The Collection Does Not Exist Not sure what I am doing wrong. The time now is 10:52 PM. They suggested adding "Application.Templates.LoadBuildingBlocks" to the code.

Any help would be great. Runtime Error 4248 Word 2013 If you are accessing the member by index number, you can use the Count property of the collection to determine if the member exists. Either way I do it, I'm still receiving the same error. Also, to make the AttachedTemplate part of the code work, you MUST change the Save In box from Building Block.dotx to the name of the template that contains the code.

Run Time Error 5941 The Requested Member Of The Collection Does Not Exist

Browse other questions tagged vba for-loop ms-word runtime-error or ask your own question. Michael S. Vba Error 4605 To get an AutoText entry, you MUST change the Gallery box from "Quick Parts" to "AutoText". Runtime Error 4248 This Command Is Not Available Because No Document Is Open Your cache administrator is webmaster.

Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. weblink Doug Robbins - Word MVP, dkr[atsymbol]mvps[dot]org Posted via the Community Bridge "Woodabyna" wrote in message news:[email protected]m... If the document you are specifying is not already open in a window, there will be no window with that "index." Try using the Documents class instead. I've checked and rechecked the file name and name of the dropdown. Run Time Error 4605 Word 2010

The most likely reason for that error is that the template you're working with does not contain an AutoText entry named "Checked Box" or "Unchecked Box". (Unfortunately VBA's error handler never Join this group Popular White Paper On This Topic The Best PDF Features Businesses Don't Use 5Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be How to grep rows that have certain value in a specific column? Michael Meyers-Jouan replied Dec 10, 2013 Yes.

In Word 2007 or 2010, AutoText has become part of the larger Building Blocks feature. Run Time Error 4605 Visual Basic more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Are you aComputer / IT professional?Join Tek-Tips Forums!

I double checked and even changed the file name and dropdown name to make sure that I was using the correct names (see below).

Would love this to work as I can not have both controls and legacy form controls in same document - good on you microsoft! Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Thanks so much for all of your help. Run-time Error '5941' Application-defined Or Object-defined Error Any suggestions are greatly appreciated.

Quicker and quieter than a mouse, what am I? Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed his comment is here Generated Tue, 01 Nov 2016 03:52:44 GMT by s_hp90 (squid/3.5.20) {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software

Using Elemental Attunement to destroy a castle Can なし be used in response to a binary question? All product names are trademarks of their respective companies. Code: Dim cnt As New ADODB.Connection Dim rst As New ADODB.Recordset Dim strDB As String Set cn = New ADODB.Connection 'Set string path to database' strDB = "C:\users\stacy\documents\my data sources\PEI.accdb" 'Open Seems that I would have to load both in order for the macro to "find" the Building Block/AutoText signature.

See ASP.NET Ajax CDN Terms of Use – ]]> Dev Center Explore Why Office? Requested Member of the Collection Does Not Exist Office 2007 Word Developer Reference The "requested member of the collection does not exist" error occurs when you try to access an object Close Box Join Tek-Tips Today! You’ll be auto redirected in 1 second.

What's this I hear about First Edition Unix being restored? Any help would be great. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016, Inc. Adding Controls to a Document Adding Controls to a UserForm Applying Formatting to Text Assigning Ranges Auto Macros Automating Common Word Tasks Built-in Dialog Box Argument Lists Communicating with Other Applications

I put an Amount - 1 in my For i statement and it is now working without error. To start viewing messages, select the forum that you want to visit from the selection below. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. I have saved as a template (.dotm) and then saved document as a .docm but always get the same error.

vba ms-word word-vba share|improve this question edited Jun 8 '15 at 11:41 Deduplicator 28.3k63366 asked Jun 8 '15 at 9:03 Danny 86 add a comment| 1 Answer 1 active oldest votes Is there an English idiom for provocative titles, something like "yellow title"? I am trying to simply create a series of macros that assistants can use to insert a signature building block into a document. Please try the request again.