Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Was George Lucas involved with Rogue One? Is it possible to replace a file with a hard link to /dev/null? Are you aComputer / IT professional?Join Tek-Tips Forums! have a peek here
Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Sunday, July 10, 2011 2:16 PM Reply | Quote 1 Sign in to vote Sounds right. i tested your code without error, so i can only assume that the active document does not contain a dropdown named dropdown1 try documents("templte1").activate or better With Documents("template1").FormFields("Dropdown1").DropDown.ListEntries i do my Browse other questions tagged vba ms-word word-vba or ask your own question.
Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? vDeptCode = ActiveDocument.FormFields("bkDeptCode").Result BTW: do you see ANYTHING about a bookmark in that? Yes I am using Word 2010 and Windows 7 64 bit.
I now have a little house icon with HomeAddress macro on the Quick Access bar which is exactly what I have wanted for ages. There you can choose a picture and change the "Display name". (I'm looking at Word 2007, where the names of things are a bit different. Big numbers: Ultrafactorials Which order to perform downsampling and filtering? The Requested Member Of The Collection Does Not Exist Word 2013 How to make sure that you get off at the correct bus stop in Thailand?
Since when has Darth Vader had a sense of humor? Run-time Error '5941' Application-defined Or Object-defined Error I have a different issue now so I will mark this as resolved and put out a new post. With ActiveDocument.Bookmarks .Add Name:="SerialNumber", Range:=Rng1 End With ActiveDocument.Save End Sub The debug brings me to this line: Set Rng1 = ActiveDocument.Bookmarks("SerialNumber").Range I am at wits end and am not sure how Join them; it only takes a minute: Sign up 5941 Error The requested member of the collection does not exist Word Macro up vote 0 down vote favorite Good Day all.
All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Runtime Error 4248 Word 2013 Can you see the starting and the ending of a light beam passing in the distance? 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 I'm using the followiing object libraries: Word & Access 12.0, Forms 2.0.
Failed to find the 'fCust' bookmark in " & sourceDocument.Name Exit Sub End If Set destDocument = Documents.Open (FileName:= _ "\\SERVERSHARE\HCD\HCD General\Templates\Heavy Cranes ICO Booking Form.docx", _ ConfirmConversions:=False, ReadOnly:=False, AddToRecentFiles:=False, _ Bach prelude BWV 924 Does a byte contains 8 bit, or 9? Vba Error 4605 Why do we complete wing bending tests? Runtime Error 4248 This Command Is Not Available Because No Document Is Open Hope you can find what I am obviously missing!
Your cache administrator is webmaster. navigate here If you are not, it could be something as simple as a typo. Are you using Option Explicit? Click Here to join Tek-Tips and talk with other members! Run Time Error 4605 Word 2010
It might be a clue that when I start with the blank document and create the macro, this then works with that open document. I have the address layout stored in Quick Parts, so having brought up a blank normal document on screen, I usually go to Quick Parts and insert the block and then By joining you are opting in to receive e-mail. Check This Out They are NOT the same.
Title = "Print" ' Set default. Runtime Error 4248 Word 2010 Please try the request again. Dim sourceDocument As Document Dim destDocument As Document Set sourceDocument = ActiveDocument If sourceDocument.Bookmarks.Exists("fCust") = False Then MsgBox "You are not using the correct source document.
Hope This Helps, PH.FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?FAQ181-2886: How can I maximize my chances of getting an answer? Join them; it only takes a minute: Sign up Runtime Error '5941' The Requested Member of Collection Does Not Exist up vote 0 down vote favorite When running the macro I But when I run this from Command Button 1 to check if record exists NB comments have not been changed from orig code [FONT=Arial]Private Sub CommandButton1_Click()[/FONT] [FONT=Arial] 'declare variables for new Run Time Error 5941 Word 2013 I've checked and rechecked the file name and name of the dropdown.
Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Reply With Quote Quick Navigation Office Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net CodeBank Visual Basic 6 Now could you please tell me how to rename it and assign it to a button with icon on Quick Access. http://evollux.net/time-error/word-macro-run-time-error-5941.html 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.
The time now is 10:54 PM. I am trying to make a macro which will insert my address etc on a blank document. I'm still pretty green at this so I would greatly appreciate any help...I'm sure it's something dumb that I'm just missing so thank you for your patience and assistance. What is the meaning behind the "all shapes and sizes" dialogue in Pulp Fiction?
If you are not, it could be something as simple as a typo. Stack Overflow Podcast #97 - Where did you get that hat?! Generated Wed, 21 Dec 2016 05:53:55 GMT by s_hp94 (squid/3.5.20) Dev Center Explore Why Office? Are you using Option Explicit?
Your cache administrator is webmaster. Related 1Error in a Word VBA macro, trying to insert values into bookmarks9Create new Word document with macro in C#2Word letterhead generating macro does not apply formatting consistently0Excel to Word Macro0Word I've checked the bookmarks by using Edit|Go To|Bookmark.