Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation Problems
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00861104
Message ID:
00861183
Views:
26
I started thinking about this some more & I think I found out why it was having the problem. Why it was intermittent is a problem for another beer.

The FileToStr("MyIni.ini") worked fine when the object was instantiated from VFP because I was running it from that directory - der! When I ran it as a Com Server from Excel who knows where the default dir was. A good question is why it worked after first registering it and then not again.

I changed the reading in of the INI to this:

cIniStr = FILETOSTR((ADDBS(JUSTPATH(This.ClassLibrary)) + 'MyIni.ini'))

Works like a charm every time now from Excel.

Hopefully this thread will help someone else later - or me next week when I've forgotten the whole mess <g>.

Thanks again.

-Matt
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform