Mike I really appreciate you're taking the time to do this I'll box on and test further
S On Sat, Jun 25, 2011 at 4:26 PM, Mike Copeland <[email protected]> wrote: > 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.
