If you are using pharo 7, you have to install a different branch of the project. Check in the documentation of pharo-com(the read me in the same repo)
On Sun, Apr 5, 2020, 21:41 PBKResearch <pe...@pbkresearch.co.uk> wrote: > Hello Pablo > > Many thanks for the suggestion. I have tried to use Pharo-Com to connect > to Outlook, and have now got myself into a complete tangle. I have been > able to connect to my already-running copy of Outlook, but when I tried to > enter propertyNamed: 'Folders', an error message appeared with the text: > "Instance of FFIExternalObjectType did not understand > emitArgument:context:inCallout:". > I could not understand this, so I closed the debugger, assuming the > effects would be unwound. > > I found that, whatever I tried after that, the same message appeared. In > desperation I closed down Pharo, without saving the image, and started > again. Whatever I tried in using Pharo-Com, the exact same message > appeared. Even when I tried running one of your tests, the same message. > > It seems clear that something in my system, not part of Pharo, has been > changed in a way which persists from one run of Pharo to another. I have no > idea what it can be, but I see that some parts of Pharo-Com address the > registry, so I wonder if I have corrupted that in some way. > > For the time being I have stopped work on Pharo-Com. I hope that a night's > sleep will bring inspiration. In case it means anything to you, I attach a > screenshot of the error stack when I try to run the testWord case in > PharoCOM-Tests. > > Thanks again > > Peter Kenny > > -----Original Message----- > From: Pharo-users <pharo-users-boun...@lists.pharo.org> On Behalf Of > teso...@gmail.com > Sent: 05 April 2020 16:23 > To: Any question about pharo is welcome <pharo-users@lists.pharo.org> > Subject: Re: [Pharo-users] Automation of MS Office from Pharo > > Hello, > One of the alternatives to integrate with Office is the use of the COM > interface. There is an implementation in > https://github.com/tesonep/pharo-com. In the test package, there are > examples to integrate with Word, Excell, Internet Explorer, and Access. > Integration with Outlook can be done in the same fashion. It is good that > the API of all the Office products is heavily documented. > > You can get more information about how to use Outlook here: > > https://docs.microsoft.com/en-us/office/vba/api/overview/outlook/object-model > > If you have any questions, please let me know. > Cheers, > Pablo. > > On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <pe...@pbkresearch.co.uk> > wrote: > > > > Hello All > > > > > > > > I am using Pharo (currently P7, moving to P8) under Windows 10. I have > MS Office 365 on my system, and use it regularly for non-Smalltalk tasks. > It would be very convenient if I could issue commands to MS Office > components from within Pharo. My current interest is to manage my incoming > e-mails in Outlook, but I can see many other applications. I have a > recollection of seeing a reference to automation of Excel to transfer data > both ways, but I cannot recall where. I have searched the catalog, but > could not see anything that looked relevant. I have also read the uFFI > booklet, but again no luck. Could anyone point me to any information or > examples of such control, please? It would not have to be Outlook, though > that is my main interest; given examples for other Office components, I > should be able to follow the pattern. > > > > > > > > TIA > > > > > > > > Peter Kenny > > > > -- > Pablo Tesone. > teso...@gmail.com >
