[AccessD] Automation Error

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 




More information about the AccessD mailing list