Ok, I was trying to find an easy solution. I will try tomorrow morning to see the problem. Sorry,
On Sun, Apr 5, 2020 at 10:29 PM PBKResearch <pe...@pbkresearch.co.uk> wrote: > > 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 <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> 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 -- Pablo Tesone. teso...@gmail.com
