Lotus Notes Error 207 Automation Object Error
Training Support Forums & community Events Rational Tivoli WebSphere Java technology Linux Open source SOA and Web services Web development XML My developerWorks About dW Submit content Feedback developerWorks>Lotus>Forums & community>Notes/Domino 6 and 7 Forum Notes/Domino 6 and 7 Forum RE: Automation Object Error:-207 Sign in to participate Previous Next RE: Automation Object Error:-207Posted by P Dan on 13.Jan.09 at 05:51 AM using a Web browserCategory: Domino DesignerRelease: All ReleasesPlatform: All Platforms Hi , Excel is installed in the system. We are facing the problem when we are running the same piece of code for the office 2007. for office 2003 it is working fine .Any idea. Return to top Automation Object Error:-207 (P Dan 13.Jan.09) . . RE: Automation Object Error:-207 (Vinit Tyagi 13.Jan.09) . . . . RE: Automation Object Error:-207 (P Dan 13.Jan.09) . . . . . . RE: Automation Object Error:-207 (Paul K Smerdon 13.Jan.09) . . RE: Automation Object Error:-207 (t ge 13.Jan.09) . . . . RE: Automation Object Error:-207 (P Dan 14.Jan.09) Document Options Document options Print this page Search this forum Search this forum Forum views and search Forum views and search Date (threaded) Date (flat) With excerpt Author Category Platform Release Advanced search Sign In or Register Sign In or Register Sign in Forgot your password? Forgot your user name? Create new registration Member Tools RSS Feeds RSS feeds All forum posts RSSAll main topics RSSMore Lotus RSS feeds Resources Resources Forum use and etiquette Native Notes Access Web site Feedback Lotus Support Lotus Support IBM Support Portal - Lotus software Lotus Support documents Lotus support by product Lotus support downloads Lotus support RSS feeds Wikis Wikis IBM Composite Applications IBM Mashup Center IBM Connections IBM Connections Cloud Developers IBM Docs IBM Forms IBM Mobile Connect IBM Sametime IBM SmartCloud for Social Business IBM Web Experience Factory Lotus Domino Lotus Domino Designer Lotus Expeditor Lotus Foundations Lotus iNotes
Training Support Forums & community Events Rational Tivoli WebSphere Java technology Linux Open source SOA and Web services Web development XML My developerWorks About dW Submit content Feedback developerWorks>Lotus>Forums & community>Notes/Domino 4 and 5 Forum Notes/Domino 4 and 5 Forum RE: "Error 207 - Automation object error"? RE: "Error 207 - Automation object error"?Posted by Diane S Spencer on 16.Jul.03 at 08:54 AM using a Web browserCategory: Domino Designer -- LotusScriptRelease: 5.0.11Platform: All Platforms Problem solved. I changed this line of code: Set wrdObj = CreateObject("Word.Application.8") to this: http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllFlatweb/0847f3d5994cda168525753d003b9c04?OpenDocument Set wrdObj = CreateObject("Word.Application") I guess the server version of Word was not the same as my desktop version. It works now!! Return to top "Error 207 - Automation object erro... (Diane S Spencer... 3.Jul.03) . . RE: "Error 207 - Automation object ... (Diane Mocny 3.Jul.03) . . . . RE: "Error 207 - Automation object ... (Diane S Spencer... http://www-10.lotus.com/ldd/46dom.nsf/e5f5333619f2996885256a220009508f/90a69821d691b9a385256d650046e213?OpenDocument 3.Jul.03) . . RE: "Error 207 - Automation object ... (Diane S Spencer... 16.Jul.03) . . . . RE: "Error 207 - Automation object ... (Diane S Spencer... 12.Sep.03) Document options Print this page Search this forum Forum views and search Date (threaded) Date (flat) With excerpt Author Category Platform Release Advanced search RSS feeds All forum posts RSSAll main topics RSSMore Lotus RSS feeds Resources Forum use and etiquette Native Notes Access Web site Feedback Lotus Support Lotus Support Product support pages index Search knowledge base (Technotes) Search support downloads Lotus Support RSS Wikis IBM Composite Applications IBM Mashup Center IBM Connections IBM Docs IBM Forms IBM Mobile Connect IBM Sametime IBM SmartCloud for Social Business IBM Web Experience Factory Lotus Domino Lotus Domino Designer Lotus Expeditor Lotus Foundations Lotus iNotes Lotus Instructor Community Courseware Lotus Notes Lotus Notes & Domino Application Development Lotus Notes Traveler Lotus Protector Lotus Quickr Lotus Symphony IBM Web Content Manager WebSphere Portal Lotus Forums Notes/Domino 9.0 Notes/Domino 8.5 + Traveler Notes/Domino XPages development forum Notes/Domino 8 Notes/Domino 6 and 7 Notes/Domino 4 and 5 IBM Connections IBM Forms IBM Mo
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help https://www.experts-exchange.com/questions/20314244/Automation-object-error-when-going-from-lotus-notes-to-excel-97.html Create a Freelance Project Hire for a Full Time Job Ways to http://stackoverflow.com/questions/10335021/automation-object-error-adding-a-bookmark-in-ms-word-2007-with-vba-in-lotus-note Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Automation object error when going from lotus notes to excel 97 Want to Advertise Here? Solved Automation object error lotus notes when going from lotus notes to excel 97 Posted on 2002-06-20 Visual Basic Classic 1 Verified Solution 24 Comments 1,735 Views Last Modified: 2012-06-21 Hello this is a part of my code. I am in Lotus Notes and in LS i'am trying to create and manipulate all sort of things in an excel file. The lotus notes program lotus notes error works on the server but the clients my have office2000 (excel.9) or office97 (excel.8). The code works perfect for office 2000 but gives the error message " automation object error " in the line Excel.visible for an office 97. What i think is strange is that the errormessage comes after the Errorhandling part ( If Err Or( Excel Is Nothing) Then ) Is there a simple workaround????? the code : Dim Excel As Variant Dim xlsheet As Variant filename = "C:\Addressbook_"+"name"+".xls" Set Excel = CreateObject("Excel.application") If Err Or( Excel Is Nothing) Then Messagebox("oopssss wrong excel version") Exit Sub End If >>>>> get stuck here >>>>> Excel.Visible = No Excel.Workbooks.add Set xlsheet = Excel.Workbooks(1).Worksheets(1) xlsheet.Activate xlsheet.Name = "Contacts" 0 Question by:ruddi Facebook Twitter LinkedIn Google LVL 44 Best Solution bybruintje and when you change them just to test it out to US? there where problems with Finish settings so that's why i said it may be far off Go to Solution 24
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Automation Object Error adding a bookmark in MS Word 2007 with VBA in Lotus Notes, works in MS Word 2003 up vote 0 down vote favorite I have some VBA code which, executing within Lotus Notes, creates a MS Word Document based on a MS Word 2003 template. This works fine for me with Word 2003, 2007 and 2010. One customer however with MS Word 2007 get the error Automation Object Error at the line: vBookmarkRange.Text = sValue Call wdObject.ActiveDocument.Bookmarks.Add(sField, vBookmarkRange) What could cause this code to fail in MS Word 2007 for a customer while it works for me with MS Word 2007? vba ms-word lotus-notes share|improve this question edited Sep 12 '12 at 12:47 kiamlaluno 15.3k124876 asked Apr 26 '12 at 13:59 Tony Guiheen 4301826 A shot in the dark: Plz check his/her security settings. Also would it be possible for you to debug the code on his/her machine? –Siddharth Rout Apr 26 '12 at 14:50 Also check if her Notes and Word were properly installed and not somehow "imaged", as this usually does not set all the Registry settings necessary for COM to work. –leyrer Apr 26 '12 at 16:42 Yes, I can debug on her machine. What security settings exactly do I need to check? How can I check whether the applications were "imaged"? Thanks. –Tony Guiheen Apr 27 '12 at 7:13 Through debugging I have discovered that the problem only occ