Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Guideline for using foxobject in FOR EACH
Message
From
24/09/2019 13:19:18
 
 
To
24/09/2019 09:40:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01671042
Message ID:
01671089
Views:
67
>>>Such asynch processing might be introduced by the specific sheet/code via own COM objects. Another possible source, when out-of-process is used: createobject() ONLY guarantees creating a new/unshared process for the asked-for COM object. At any time later this COM component might be hijacked by another process wielding getobject().
>>>
>>>Again - all the above more in the region of "possible" not "probable" in environments with COM habits I consider well-reasoned ;-)
>>
>>What do you mean by "vfp COM.dll from Excel and setting up a bridge"? Would that mean to write a separate dll for VFP or another way how to reference Excel in VFP other than Createobject()?
>
>load vfp COM dll via Excel script
>call vfp method with specific Excel object as parameter
>use that parameter in vfp to query/access other Excel properties/methods
>
>Have not checked if parts of Excel can be loaded in-process, in theory possible (similar to InternetExplorer.Application out of process, MsHTML and ShDocVw in-process).

Interesting approach, I will certainly try that out.
Christian Isberner
Software Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform