Sytze
I'm testing it on VFP9SP2, Windows XP, and if I start VFP, then execute
GetObject(,'Excel.Application')
I get an OLE error.
If I include a first parameter, a reference to an XLS file
GetObject('C:\Spreadem.xls','Excel.Application')
then I do not get an error.
If I then execute the statement
GetObject(,'Excel.Application')
I do not get an OLE error, because Excel is already running.
I can't comment regarding Outlook as I do not have it installed on any
system I have access to.
Mike
> Hi Mike
> I'm now testing this on my laptop where the Createobject was running about 6
> times, but no longer.
>
> I have closed Outlook
> I've changed my code to
> oOutlook=Getobject(,"outlook.application")
>
> Error is 0x800401e3:Operation unavailable
>
> System is Outlook 2003, VFP SP2 on Windows 7/32
>
>
>
>
> On Sat, Jun 25, 2011 at 3:59 PM, Mike Copeland<[email protected]> wrote:
>
>> And so it is (correct.) The help file says that if the application is
>> already running you can prevent additional instances from being started
>> by omitting the first parameter and issuing the statement the way you
>> have shown.
>>
>> So is the application already running?
>>
>> If not, you'll get that error. If it is, you won't.
>>
>> Mike
>>
>>> Many years ago I bought the book from Hentzen, and in the examples, it
>> has a
>>> ","
>>>
>>>
>>> On Sat, Jun 25, 2011 at 3:42 PM, Mike Copeland<[email protected]>
>> wrote:
>>>> Could it be that there is a , (comma) after the left parenthesis in the
>>>> GetObject statement?
>>>>
>>>> Mike
>>>>
>>>>> Can anyone suggest why this code is wrong ?
>>>>> oOutlook = GetObject(,"Outlook.Application")
>>>>> error OLE error code 0x800401e3 etc
>>>>>
>>>>> If I change it to CreateObject
>>>>> I get OLE error 0x80010105: The server threw an exception
>>>>>
>>>>> This works fine
>>>>> ox=CreateObject("Excel.Application")
>>>>>
>>>>> I have VFP on my laptop and there's no problem, except that outlook is
>>>> not
>>>>> installed on the laptop.....
>>>>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
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.
