[AccessD] Automoation - Opening Word WAS: something else

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Tue Jan 30 11:27:37 CST 2007


Doug:

Using CreateObject as you suggest works on my machine (Outlook is closed -
no instance of WORD in the task manager) but fails at the customer site.
All variations give the same error "Automation Error (long number -  the
specified object cannot be found".

Any ideas anybody?

MTIA

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Monday, January 29, 2007 3:16 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Runtimes -
PreferablyAccessXPbut2003ifabsolutelyrequired

Rocky,

I use CreatObject
    Dim objWord As Object                    
    Set objWord = CreateObject("Word.Application")         

Doug
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, January 29, 2007 2:27 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Runtimes - Preferably
AccessXPbut2003ifabsolutelyrequired

Doug:

I'm still having trouble with a user opening a word doc and the code works
here.  So I'm switching to late binding.

Would the correct code for late binding be:

Dim objWord As Object
Set objWord = GetObject("", "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

Where Me.fldFABWorkInstructions contains the full path and file ame of the
word doc to be opened.  BTW this code works on my machine.  And we are both
running O2003.

TIA

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Monday, January 29, 2007 9:51 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Runtimes - Preferably AccessXP
but2003ifabsolutelyrequired

John,

I automate Word from an XP runtime with no problem.  I used late binding to
make sure changes in the Version of Word being used didn't crash the system.

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Sunday, January 28, 2007 6:22 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Runtimes - Preferably AccessXP but
2003ifabsolutelyrequired

I found a 2000 package on ebay but not an XP version.

What happens with automating word and excel? 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten
Sent: Sunday, January 28, 2007 9:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Runtimes - Preferably AccessXP but 2003
ifabsolutelyrequired

Hi John,

I believe you need the Office XP Developer package. There are a few listed
on the web, for around $600. There is an update package but I don't know if
it requires a previous developer package or not. Amazon lists it but is
currently out. A full package is currently on EBay. I am of the opinion that
the developer license allows you to distribute as many runtimes as you need
to service projects that you deliver.

HTH


Bill

----- Original Message -----
From: "JWColby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Sunday, January 28, 2007 5:55 PM
Subject: [AccessD] Runtimes - Preferably AccessXP but 2003 if
absolutelyrequired


Can anyone give me "just the facts ma'm" for what I need to buy to do
runtimes for a single site, IOW 40 machines all at the same location.  All
machines are Windows 2K or XP.  The application uses automation to do mail
merge.  Also automation to use Outlook.  Outlook uses exchange server if it
matters.

The client currently has a mix of office 2K and XP and it causing headaches
getting one version of the application to work on both versions of office
everywhere, every time.

I need to know the cost, how to get ahold of it etc.  The Microsoft site
runs you around and around (trying to avoid the cost issue I assume).

John W. Colby
Colby Consulting
www.ColbyConsulting.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.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.12/655 - Release Date: 1/28/2007
1:12 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.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.12/655 - Release Date: 1/28/2007
1:12 PM
 




More information about the AccessD mailing list