Re: Help - cannot create word.application
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
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
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
> >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
> 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
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
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
...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
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
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.