Pablo – Yes, I saw the instruction. I used the quoted Metacello procedure for P7 – I used copy and paste from the repo Readme. Peter
From: Pharo-users <pharo-users-boun...@lists.pharo.org> On Behalf Of teso...@gmail.com Sent: 05 April 2020 21:19 To: Any question about pharo is welcome <pharo-users@lists.pharo.org> Subject: Re: [Pharo-users] Automation of MS Office from Pharo The install instructions are not the same for Pharo 7, or pharo 8/9 On Sun, Apr 5, 2020, 22:18 teso...@gmail.com <mailto:teso...@gmail.com> <teso...@gmail.com <mailto:teso...@gmail.com> > wrote: 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 <mailto: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 <mailto:pharo-users-boun...@lists.pharo.org> > On Behalf Of teso...@gmail.com <mailto:teso...@gmail.com> Sent: 05 April 2020 16:23 To: Any question about pharo is welcome <pharo-users@lists.pharo.org <mailto: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 <mailto: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 <mailto:teso...@gmail.com>
