Re: Help - cannot create word.application

2007-06-29 Thread Paul Hill
On 6/29/07, Paul Newton <[EMAIL PROTECTED]> wrote:
> Paul Hill wrote:
> > Anyway, it'll have to wait until Tuesday.  I'm off to France for the
> > weekend for a ball (held for the anniversary of the battle of the
> > Somme).
> >
> > p.s. Has anyone seen my bow tie?
>
> Paul
>
> Have a great time.  Will there be many other survivors there ?

Just me and other few other 100 year olds!

-- 
Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Help - cannot create word.application

2007-06-29 Thread Paul Newton
Paul Hill wrote:
> Anyway, it'll have to wait until Tuesday.  I'm off to France for the
> weekend for a ball (held for the anniversary of the battle of the
> Somme).
>
> p.s. Has anyone seen my bow tie?

Paul

Have a great time.  Will there be many other survivors there ?

Paul



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Help - cannot create word.application

2007-06-29 Thread Paul Hill
On 6/29/07, Graham Dobson <[EMAIL PROTECTED]> wrote:
> Did you get it working?  You haven't given people much to go on.  Are you
> receiving OLE automation errors? or did your agent not configure the virtual
> directories porperly?  I assume Word is installed and registered properly on
> all the appropriate machines.  Best of luck.  Graham.

No :-(

Word is working and as far as I know registered. We don't actually
report automation errors (something I'll change).

I don't have a great deal to go on myself unfortunately.  I'm not
on-site and the agent is the man in the middle.  I suspect it's either
something to do with security or Office is incorrectly installed.
Pretty certain it's not our app (working fine in 100s of sites), but
you try telling the them that!

Anyway, it'll have to wait until Tuesday.  I'm off to France for the
weekend for a ball (held for the anniversary of the battle of the
Somme).

p.s. Has anyone seen my bow tie?

-- 
Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Help - cannot create word.application

2007-06-29 Thread Graham Dobson
>
>On 6/29/07, Dave Crozier <[EMAIL PROTECTED]> wrote:
>> ...and I forgot to say:
>>
>> Use GetObject(,"Word.Application") to open word if it is ALREADY running.
>
>Thanks Dave.  Here CreateObject() works even if Word is already running.
>
>I just spoke to our Irish dealer - I was wrong about the opening date.
> It's not tomorrow, it's in 2 hours time :-)
>

Did you get it working?  You haven't given people much to go on.  Are you
receiving OLE automation errors? or did your agent not configure the virtual
directories porperly?  I assume Word is installed and registered properly on
all the appropriate machines.  Best of luck.  Graham.



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Help - cannot create word.application

2007-06-29 Thread Jaime Vasquez


> I'm running out of ideas here and the hotel is going live tomorrow.
> They use these reports to print welcome letters etc for the guests so
> it's quite important.
> 
> I created a .VBS script that works the same way and this opens Word fine.
> 
> Does anyone have any ideas?  Could it be a group policy or other
> security setting???
> 
> Help!



See if your code or config.fp has SET OLEOBJECT OFF, if yes then turn to 
on, or you will don't be able to create automation objects.



HTH


Saludos,
Jaime Vasquez
Guatemala C.A.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Help - cannot create word.application

2007-06-29 Thread Richard Kaye
Depending on what automation task I'm trying to accomplish, I tend to 
wrap the initial object creation in a try..catch these days. Something 
like this:

TRY
loWord=GetObject(,"Word.Application")
CATCH
ENDTRY
IF VARTYPE(loWord)=[U]
loWord=CreateObject(,"Word.Application")
ENDIF

That way I can get the running instance if one exists and it also 
eliminates those ugly COM errors surfacing to the user when Word or 
Excel, etc. can't be found.

Dave Crozier wrote:
> ...and I forgot to say:
>  
> Use GetObject(,"Word.Application") to open word if it is ALREADY running.
>   

-- 
Richard Kaye
Vice President
Artfact/RFC Systems
Voice: 617.219.1038
Fax:  617.219.1001

For the fastest response time, please send your support
queries to:

Technical Support - [EMAIL PROTECTED]
Australian Support - [EMAIL PROTECTED]
Internet Support - [EMAIL PROTECTED]
All Other Requests - [EMAIL PROTECTED]

-
This message has been checked for viruses before sending.
-



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Help - cannot create word.application

2007-06-29 Thread Paul Hill
On 6/29/07, Dave Crozier <[EMAIL PROTECTED]> wrote:
> ...and I forgot to say:
>
> Use GetObject(,"Word.Application") to open word if it is ALREADY running.

Thanks Dave.  Here CreateObject() works even if Word is already running.

I just spoke to our Irish dealer - I was wrong about the opening date.
 It's not tomorrow, it's in 2 hours time :-)

-- 
Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Help - cannot create word.application

2007-06-29 Thread Dave Crozier
...and I forgot to say:
 
Use GetObject(,"Word.Application") to open word if it is ALREADY running.

Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Hill
Sent: 29 June 2007 14:38
To: ProFox Email List
Subject: Help - cannot create word.application

Hi All,

I've got a problem with a site that has me stumped.

Our app has a feature where users can write their own reports using
Word.  The app creates an Excel sheet and fires up a user-created Word
document that is linked to the Excel sheet and perform a mail merge.
Works great and is in use in many sites.  All done using Automation.

Now we have a new site (a Hotel) that is about to go live.  The site
was previously installed by our agent in Ireland and was working OK.

Yesterday they reported a problem.  Office reports were only working
on 2 out of the 4 PCs.  Today it's only 1 out of 4.  It looks like our
app cannot create an instance of Word -
CreateObject("word.application") seems to be failing.

They've tried re-installing Office and running as Domain Admin but
still no joy.  Also tried opening Word before running the report but
still no luck.

I'm running out of ideas here and the hotel is going live tomorrow.
They use these reports to print welcome letters etc for the guests so
it's quite important.

I created a .VBS script that works the same way and this opens Word fine.

Does anyone have any ideas?  Could it be a group policy or other
security setting???

Help!

-- 
Paul


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Help - cannot create word.application

2007-06-29 Thread Dave Crozier
Paul,

Using CreateObject will fail if an instance of Word is already running. Have
they got Outlook open as this uses Word to edit emails? In which case only
allow editing via the text editor under Options.

Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Hill
Sent: 29 June 2007 14:38
To: ProFox Email List
Subject: Help - cannot create word.application

Hi All,

I've got a problem with a site that has me stumped.

Our app has a feature where users can write their own reports using
Word.  The app creates an Excel sheet and fires up a user-created Word
document that is linked to the Excel sheet and perform a mail merge.
Works great and is in use in many sites.  All done using Automation.

Now we have a new site (a Hotel) that is about to go live.  The site
was previously installed by our agent in Ireland and was working OK.

Yesterday they reported a problem.  Office reports were only working
on 2 out of the 4 PCs.  Today it's only 1 out of 4.  It looks like our
app cannot create an instance of Word -
CreateObject("word.application") seems to be failing.

They've tried re-installing Office and running as Domain Admin but
still no joy.  Also tried opening Word before running the report but
still no luck.

I'm running out of ideas here and the hotel is going live tomorrow.
They use these reports to print welcome letters etc for the guests so
it's quite important.

I created a .VBS script that works the same way and this opens Word fine.

Does anyone have any ideas?  Could it be a group policy or other
security setting???

Help!

-- 
Paul


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Help - cannot create word.application

2007-06-29 Thread Paul Hill
Hi All,

I've got a problem with a site that has me stumped.

Our app has a feature where users can write their own reports using
Word.  The app creates an Excel sheet and fires up a user-created Word
document that is linked to the Excel sheet and perform a mail merge.
Works great and is in use in many sites.  All done using Automation.

Now we have a new site (a Hotel) that is about to go live.  The site
was previously installed by our agent in Ireland and was working OK.

Yesterday they reported a problem.  Office reports were only working
on 2 out of the 4 PCs.  Today it's only 1 out of 4.  It looks like our
app cannot create an instance of Word -
CreateObject("word.application") seems to be failing.

They've tried re-installing Office and running as Domain Admin but
still no joy.  Also tried opening Word before running the report but
still no luck.

I'm running out of ideas here and the hotel is going live tomorrow.
They use these reports to print welcome letters etc for the guests so
it's quite important.

I created a .VBS script that works the same way and this opens Word fine.

Does anyone have any ideas?  Could it be a group policy or other
security setting???

Help!

-- 
Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.