April 2020 - Pharo-users - lists.pharo.org

Re: [Pharo-users] [Spec] List and notebook page

by Esteban Lorenzano

Probably the order of properties change triggering will affect the others. It depends on how you connected the presenters originally (aka: clearContent will maybe trigger something, etc.). Esteban > On 29 Mar 2020, at 17:56, Hilaire <hilaire(a)drgeo.eu> wrote: > > I resolved the issue, but it looks counter intuitive. Any rational? > > connectPresenters > scripts whenSelectedItemChanged: [ :class | > source clearContent; behavior: nil. > class ifNotNil: [ > methods resetAllPageContents. > (methods pageAt: 1) whenRetrievedDo: [ :list | list items: class methods]. > (methods pageAt: 2) whenRetrievedDo: [ :list | list items: class class methods]. > methods resetAllPageContents.]]. > -- > Dr. Geo > http://drgeo.eu <http://drgeo.eu/>

April 6, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by TomaÅ¾ Turk

Hello Peter, If you look at the code in the Word test you will notice that the test firstly - creates a new Word instance, - makes it visible to the end user, - then adds an empty document to the documents collection with the text "Hello from Pharo!" - then it tests whether it can receive the same text back from Word. After that, the test - adds a new empty document to the documents collection with the text "Hello from Pharo! Some additional text. ", this time as an array of two texts - it activates this second document (this imitates the end user's window activation on the desktop) - then it tests whether it can receive the same text back from Word. If you look at the Task Manager, you'll notice that you have one Word process with two open documents: Namely, for each document Word creates a new, separate window - the documents are not displayed in one "Word application window", but separately - that's a normal behavior for some versions of MS Office, and it happens also if you open several documents directly in Word. So, there is just one Word instance. 'finalize' clears the references to the Word instance, it doesn't close the program by itself. If you want to do that, you can send Quit message to Word before you destroy the reference (https://docs.microsoft.com/en-us/office/vba/api/word.application.quit(metho…) Similar behaviour is with Outlook, here's one example: https://www.excelcommand.com/excel-help/excel-how-to.php?i=124116 The calling among COM objects is asynchronous, and it's usually wise to wrap it in error handling structures. Please tell us how it goes. Best wishes, Tomaz ------ Original Message ------ From: "PBKResearch" <peter(a)pbkresearch.co.uk> To: "Any question about pharo is welcome" <pharo-users(a)lists.pharo.org> Sent: 5.4.2020 23:18:02 Subject: Re: [Pharo-users] Automation of MS Office from Pharo >Pablo - a final update before I close for the night. The Word test on the pharo 8 version comes up green. The strange error message is nowhere to be seen in any Pharo 8 runs. The result is not what I expected; I finish up with two Word documents open, one with the first message, the other with the two messages. I thought the 'finalize' command would close it down. > >Anyway, it looks as if I need to switch to P8 to use Pharo-Com. I shall continue testing tomorrow on P8. > >Sorry for the late-night hassle. > >Peter >

April 6, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by PBKResearch

Pablo - a final update before I close for the night. The Word test on the pharo 8 version comes up green. The strange error message is nowhere to be seen in any Pharo 8 runs. The result is not what I expected; I finish up with two Word documents open, one with the first message, the other with the two messages. I thought the 'finalize' command would close it down. Anyway, it looks as if I need to switch to P8 to use Pharo-Com. I shall continue testing tomorrow on P8. Sorry for the late-night hassle. Peter -----Original Message----- From: Pharo-users <pharo-users-bounces(a)lists.pharo.org> On Behalf Of PBKResearch Sent: 05 April 2020 21:57 To: 'Any question about pharo is welcome' <pharo-users(a)lists.pharo.org> Subject: Re: [Pharo-users] Automation of MS Office from Pharo Pablo - Thanks for this. Just one bit of news. While I was waiting, I opened a new Pharo 8 image, installed Pharo-Com 9the right one!) and tried to run some of your tests. The Word test started to work, then stopped saying 'test took too long'. But it did open a Word document, and in one trial it printed the opening message. The variant tests were all green. So there are signs that the problem lies with P7. So don't worry too much about me - I probably fouled something up. Peter. -----Original Message----- From: Pharo-users <pharo-users-bounces(a)lists.pharo.org> On Behalf Of tesonep(a)gmail.com Sent: 05 April 2020 21:47 To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> Subject: Re: [Pharo-users] Automation of MS Office from Pharo 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 <peter(a)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-bounces(a)lists.pharo.org> On Behalf Of > tesonep(a)gmail.com > Sent: 05 April 2020 21:19 > To: Any question about pharo is welcome <pharo-users(a)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 tesonep(a)gmail.com <tesonep(a)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 <peter(a)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-bounces(a)lists.pharo.org> On Behalf Of > tesonep(a)gmail.com > Sent: 05 April 2020 16:23 > To: Any question about pharo is welcome <pharo-users(a)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/objec > t-model > > If you have any questions, please let me know. > Cheers, > Pablo. > > On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)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. > tesonep(a)gmail.com -- Pablo Tesone. tesonep(a)gmail.com

April 5, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by PBKResearch

Pablo - Thanks for this. Just one bit of news. While I was waiting, I opened a new Pharo 8 image, installed Pharo-Com 9the right one!) and tried to run some of your tests. The Word test started to work, then stopped saying 'test took too long'. But it did open a Word document, and in one trial it printed the opening message. The variant tests were all green. So there are signs that the problem lies with P7. So don't worry too much about me - I probably fouled something up. Peter. -----Original Message----- From: Pharo-users <pharo-users-bounces(a)lists.pharo.org> On Behalf Of tesonep(a)gmail.com Sent: 05 April 2020 21:47 To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> Subject: Re: [Pharo-users] Automation of MS Office from Pharo 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 <peter(a)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-bounces(a)lists.pharo.org> On Behalf Of > tesonep(a)gmail.com > Sent: 05 April 2020 21:19 > To: Any question about pharo is welcome <pharo-users(a)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 tesonep(a)gmail.com <tesonep(a)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 <peter(a)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-bounces(a)lists.pharo.org> On Behalf Of > tesonep(a)gmail.com > Sent: 05 April 2020 16:23 > To: Any question about pharo is welcome <pharo-users(a)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/objec > t-model > > If you have any questions, please let me know. > Cheers, > Pablo. > > On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)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. > tesonep(a)gmail.com -- Pablo Tesone. tesonep(a)gmail.com

April 5, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by tesonep＠gmail.com

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 <peter(a)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-bounces(a)lists.pharo.org> On Behalf Of tesonep(a)gmail.com > Sent: 05 April 2020 21:19 > To: Any question about pharo is welcome <pharo-users(a)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 tesonep(a)gmail.com <tesonep(a)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 <peter(a)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-bounces(a)lists.pharo.org> On Behalf Of tesonep(a)gmail.com > Sent: 05 April 2020 16:23 > To: Any question about pharo is welcome <pharo-users(a)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-mod… > > If you have any questions, please let me know. > Cheers, > Pablo. > > On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)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. > tesonep(a)gmail.com -- Pablo Tesone. tesonep(a)gmail.com

April 5, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by PBKResearch

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-bounces(a)lists.pharo.org> On Behalf Of tesonep(a)gmail.com Sent: 05 April 2020 21:19 To: Any question about pharo is welcome <pharo-users(a)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 tesonep(a)gmail.com <mailto:tesonep@gmail.com> <tesonep(a)gmail.com <mailto:tesonep@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 <peter(a)pbkresearch.co.uk <mailto:peter@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-bounces(a)lists.pharo.org <mailto:pharo-users-bounces@lists.pharo.org> > On Behalf Of tesonep(a)gmail.com <mailto:tesonep@gmail.com> Sent: 05 April 2020 16:23 To: Any question about pharo is welcome <pharo-users(a)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-mod… If you have any questions, please let me know. Cheers, Pablo. On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)pbkresearch.co.uk <mailto:peter@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. tesonep(a)gmail.com <mailto:tesonep@gmail.com>

April 5, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by tesonep＠gmail.com

The install instructions are not the same for Pharo 7, or pharo 8/9 On Sun, Apr 5, 2020, 22:18 tesonep(a)gmail.com <tesonep(a)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 <peter(a)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-bounces(a)lists.pharo.org> On Behalf Of >> tesonep(a)gmail.com >> Sent: 05 April 2020 16:23 >> To: Any question about pharo is welcome <pharo-users(a)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-mod… >> >> If you have any questions, please let me know. >> Cheers, >> Pablo. >> >> On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)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. >> tesonep(a)gmail.com >> >

April 5, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by tesonep＠gmail.com

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 <peter(a)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-bounces(a)lists.pharo.org> On Behalf Of > tesonep(a)gmail.com > Sent: 05 April 2020 16:23 > To: Any question about pharo is welcome <pharo-users(a)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-mod… > > If you have any questions, please let me know. > Cheers, > Pablo. > > On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)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. > tesonep(a)gmail.com >

April 5, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by PBKResearch

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-bounces(a)lists.pharo.org> On Behalf Of tesonep(a)gmail.com Sent: 05 April 2020 16:23 To: Any question about pharo is welcome <pharo-users(a)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-mod… If you have any questions, please let me know. Cheers, Pablo. On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)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. tesonep(a)gmail.com

April 5, 2020

Re: [Pharo-users] Automation of MS Office from Pharo

by tesonep＠gmail.com

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-mod… If you have any questions, please let me know. Cheers, Pablo. On Sun, Apr 5, 2020 at 2:44 PM PBKResearch <peter(a)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. tesonep(a)gmail.com

April 5, 2020