Michael R Mattys
mmattys at rochester.rr.com
Fri Jan 19 19:20:33 CST 2007
Maybe try this: Dim objWord As Word.Application Set objWord = New Word.Application Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com ----- Original Message ----- From: "Beach Access Software" <bchacc at san.rr.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Friday, January 19, 2007 7:20 PM Subject: Re: [AccessD] Automation Error >I changed Dim objWord As Word.Application to Dim objWord As Object trying > for Late Binding (like I know what I'm doing). But no soap. Same > Automation Error. > > Any ideas anybody? > > MTIAA > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.e-z-mrp.com > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access > Software > Sent: Friday, January 19, 2007 1:59 PM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Automation Error > > Dear List: > > > > My client is getting an automation error in the Set ojbWord statemenet > below > although the code works on my machine. I have checked to see that the > Word > 11.0 object library is checked in references on his machine. What else > could cause this problem? > > > > Dim objWord As Word.Application > > Dim objWordDoc As Word.Document > > > > Set objWord = CreateObject("Word.Application") > > > > With objWord > > 'Visible is set True in order to view the operation. > > .Visible = True > > .Documents.Open (Me.fldFABWorkInstructions) > > End With > > > > Set objWord = Nothing > > > > MTIA, > > > > Rocky Smolin > > Beach Access Software > > 858-259-4334 > > www.e-z-mrp.com > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.0/639 - Release Date: 1/18/2007 > 6:47 PM > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com