Guest We have an macro linked in our letter macro that will add three addresses at the bottom of the footer when you select the Personal Injury Macro. That's why I explained how to add a window for a file that is open. The > code is apparently trying to do something with something that doesn't > exists (e.g., put text in a table cell that doesn't exist). The SMB of the Future: Start Fast, Then Accelerate MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... get redirected here
Click in the code window and step through the macro using the F8 key to try to determine the line of code that throws the error. Tonya C. Tonya C. I've checked the bookmarks by using Edit|Go To|Bookmark.
You're now being signed in. Join them; it only takes a minute: Sign up Runtime Error '5941' The Requested Member of Collection Does Not Exist up vote -1 down vote favorite When running the macro I Not the answer you're looking for? 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
Is it posible to hook the tilt of a curve's point? 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' Sign up now! Runtime Error 4248 This Command Is Not Available Because No Document Is Open BernRI replied Dec 9, 2013 Thanks for the help but it still gives me an error but now on the revised Documents("Kit Label Framework.docx").Open it gives me a run-time error 438
View All Topics View All Members View All Companies Toolbox for IT Topics Visual Basic Groups Ask a New Question Visual Basic for Applications A forum where peers share technical expertise, If you are not, it could be something as simple as a typo. Why does this progression alternating between major and minor chords sound right? https://support.microsoft.com/en-us/kb/290934 Now when we select the letter macro and pick the >>> Personal Injury selection, we get the Run Time Error 5941 - The >>> requested member of the collection does not
Hi Gerry, I now have to admit to being very dense I had thought that the bk in the code was identifying the bookmark Obviously not - it was part of http://www.tek-tips.com/viewthread.cfm?qid=1682609 If you're having a computer problem, ask on our forum for advice. Run-time Error 5941 Microsoft Visual Basic Already a member? Vba Error 4605 Just click the sign up button to choose a username and then you can ask your own questions on the forum.
I'm in design mode and I click on "Insert a dropdown list content control". Hello and welcome to PC Review. I've even manually added text the dropdown to make sure that it worked. Greg Maxey, Oct 6, 2009 #3 Pesach Shelnitz Guest -- Hope this helps, Pesach Shelnitz "Gordon Bentley-Mix" wrote: > Two suggestions: > > 1. Run Time Error 5941 Word Macro
Are you aComputer / IT professional?Join Tek-Tips Forums! share|improve this answer answered Jun 8 '15 at 10:09 ChipsLetten 2,3181319 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign Multiple-Key Sorting 5D MkIII - how to maintain exposure (ratio) in M How to indicate you are going straight? useful reference Specifically, I'm receiving the Runtime error "5941" The requested member of the collection does not exist.
Login with LinkedIN Or Log In Locally Email or Username Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Runtime Error 4248 Word 2013 Advanced Search VBForums Visual Basic Office Development [RESOLVED] Runtme Error 5941 If this is your first visit, be sure to check out the FAQ by clicking the link above. 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.
Gordon Bentley-Mix, Oct 6, 2009 #2 Advertisements Greg Maxey Guest On Oct 6, 4:56 pm, Tonya C. <> wrote: > We have an macro linked in our letter macro that will add Checked that numbers in doc map to Numbers in DB The Locals window shows Me Type ThisDocument/Document vRecordset Nothing VDept Value "" Type String I don't know enough to know whether Without it there's no way even the best of us could > discern where the problem lies. Run Time Error 4605 Word 2010 Stops at [FONT=Arial]vDeptCode = ActiveDocument.FormFields("bkDeptCode").Result[/FONT] Formatting tags added by mark007 .
image.eric, Apr 1, 2009, in forum: Microsoft Word Document Management Replies: 1 Views: 730 image.eric Apr 1, 2009 Loading... Tonya C. I am new to working with macros. Results 1 to 5 of 5 Thread: Solved: Word Runtime error '5941' Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded
That will activate the document (as long as it has been opened as a file, whether or not it has also been assigned to a window). Now when we select the letter macro and pick the >>> Personal Injury selection, we get the Run Time Error 5941 - The >>> requested member of the collection does not Could you assist me, please? "Greg Maxey" wrote: > On Oct 6, 4:56 pm, Tonya C. <> wrote: > > We have an macro linked in our letter macro that will