this is why i changed the way excel loads so that when i create an instance
to use from my app it creates a new instance and leaves any the user has
opened themselves alone
2008/9/22 Tracy Pearson <[EMAIL PROTECTED]>
> My experience has been it's a hit and miss. I never tried to figure out
> how/why I got one or the other.
>
> Tracy
>
> -----Original Message-----
> From: Chris Davis
> Sent: Monday, September 22, 2008 12:10 PM
>
> and if excel is loaded more than once ? is it possible to get access to
> either ?
>
> 2008/9/22 Dave Crozier
>
> > Rafael,
> > Allen is correct - GetObj() will grant access to a currently loaded
> Excel.
> > An error indicates that Excel is NOT loaded.
> >
> > Dave Crozier
> >
> > -----Original Message-----
> > From: Rafael Copquin
> > Sent: 22 September 2008 11:47
> >
> > I usually use this code to launch Excel via automation:
> >
> > if upper(vartype(thisform.oExcel)) <> "O"
> > thisform.oExcel=createobject("Excel.Application")
> > else
> > thisform.oExcel=getobject( , "Excel.Application") endif
> >
> > The above code was derived from the Hacker's Guide by Tamar Granor and
> > others.
> >
> > However, if I wanted to know in advance whether an instance of Excel
> > is open
> >
> > in the user's computer, is there any API call or function that would
> > tell me
> >
> > this]
> >
> > And if there is, could any of you post the code to accomplish this]
> >
> > TIA
> >
> > Rafael Copquin
>
>
>
[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.
