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

2020-04-09 Thread Ben Coman
April 2020 09:20 > To: Tomaž Turk ; Any question about pharo is > welcome > Subject: Re: [Pharo-users] Automation of MS Office from Pharo > > Cool, thanks to the three :) > > @Peter, I’d like if you tell us at the end if you had success at > automating you mail workflow ^^ >

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

2020-04-08 Thread PBKResearch
April 2020 09:20 To: Tomaž Turk ; Any question about pharo is welcome Subject: Re: [Pharo-users] Automation of MS Office from Pharo Cool, thanks to the three :) @Peter, I’d like if you tell us at the end if you had success at automating you mail workflow ^^ > El 8 abr 2020, a las 10:15, To

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

2020-04-08 Thread Guillermo Polito
d it works just fine. > > Best wishes, > Tomaz > > > -- Original Message -- > From: "teso...@gmail.com" > To: "Any question about pharo is welcome" > Cc: "Tomaž Turk" > Sent: 8.4.2020 9:54:35 > Subject: Re: [Pharo-users]

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

2020-04-08 Thread Tomaž Turk
s Peter Kenny From: Pharo-users On Behalf Of Tomaž Turk Sent: 08 April 2020 07:58 To: Any question about pharo is welcome Subject: Re: [Pharo-users] Automation of MS Office from Pharo Thanks, Stephane, for the acknowledgement. Peter, as I understand, the limits in COM BSTR data

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

2020-04-08 Thread teso...@gmail.com
> > > Peter Kenny > > > > From: Pharo-users On Behalf Of Tomaž > Turk > Sent: 08 April 2020 07:58 > To: Any question about pharo is welcome > Subject: Re: [Pharo-users] Automation of MS Office from Pharo > > > > Thanks, Stephane, for the acknowledgem

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

2020-04-08 Thread PBKResearch
this way, so it’s not a problem. Thanks Peter Kenny From: Pharo-users On Behalf Of Tomaž Turk Sent: 08 April 2020 07:58 To: Any question about pharo is welcome Subject: Re: [Pharo-users] Automation of MS Office from Pharo Thanks, Stephane, for the acknowledgement. Peter, as I

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

2020-04-07 Thread Tomaž Turk
Thanks, Stephane, for the acknowledgement. Peter, as I understand, the limits in COM BSTR data type are defined by the header's length prefix (which is 4 bytes) and software implementatios - for instance, string data type in Visual Basic for Applications is described as "a variable-length strin

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

2020-04-07 Thread PBKResearch
From: Pharo-users On Behalf Of Tomaž Turk Sent: 07 April 2020 21:27 To: Any question about pharo is welcome Subject: Re: [Pharo-users] Automation of MS Office from Pharo Thanks, Peter. I checked out the Outlook COM interface, noticed that the MailItem.HTMLBody property returns a string, which

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

2020-04-07 Thread Tomaž Turk
Thanks, Peter. I checked out the Outlook COM interface, noticed that the MailItem.HTMLBody property returns a string, which is implemented as BSTR in COM (more on this here: https://bytecomb.com/vba-internals-string-variables-and-pointers-in-depth/). I tested the maximum lengths of strings wit

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

2020-04-07 Thread PBKResearch
Peter Kenny From: Pharo-users On Behalf Of PBKResearch Sent: 07 April 2020 18:28 To: 'Tomaž Turk' ; 'Any question about pharo is welcome' Subject: Re: [Pharo-users] Automation of MS Office from Pharo Hello Tomaž I have been exploring today, to try to narrow do

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

2020-04-07 Thread PBKResearch
: Pharo-users On Behalf Of Tomaž Turk Sent: 07 April 2020 16:30 To: Any question about pharo is welcome Subject: Re: [Pharo-users] Automation of MS Office from Pharo Dear Peter, I'm glad that you find the package useful! Can you please explain a little bit more about your code, be

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

2020-04-07 Thread Tomaž Turk
that fails? Thanks and best wishes, Tomaz -- Original Message -- From: "PBKResearch" To: "Any question about pharo is welcome" Sent: 6. 04. 2020 19:15:16 Subject: Re: [Pharo-users] Automation of MS Office from Pharo Hello Pablo (and Tomaž) You asked for feedback; afte

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

2020-04-06 Thread PBKResearch
welcome Subject: Re: [Pharo-users] Automation of MS Office from Pharo Hi Peter, First, thanks to try to use Pharo-COM, that is great, I love to have users for it and find it is useful. Secondly, the Pharo 7 problem is an error I have introduced. It is clear that some changes I have done

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

2020-04-06 Thread teso...@gmail.com
om here, but I shall come back if I get > stuck. > > > > Thanks again > > > > Peter Kenny > > > > *From:* Pharo-users *On Behalf Of *Tomaž > Turk > *Sent:* 06 April 2020 08:04 > *To:* Any question about pharo is welcome > *Subject:* Re: [Pharo-users] Automatio

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

2020-04-06 Thread PBKResearch
from here, but I shall come back if I get stuck. Thanks again Peter Kenny From: Pharo-users On Behalf Of Tomaž Turk Sent: 06 April 2020 08:04 To: Any question about pharo is welcome Subject: Re: [Pharo-users] Automation of MS Office from Pharo Hello Peter, If you look at the

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

2020-04-06 Thread Tomaž Turk
uot;Any question about pharo is welcome" 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

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

2020-04-05 Thread PBKResearch
earch Sent: 05 April 2020 21:57 To: 'Any question about pharo is welcome' 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

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

2020-04-05 Thread PBKResearch
5 April 2020 21:47 To: Any question about pharo is welcome 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 wrote: > > Pablo – Yes, I s

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

2020-04-05 Thread teso...@gmail.com
me. Peter > > > > From: Pharo-users On Behalf Of > teso...@gmail.com > Sent: 05 April 2020 21:19 > To: Any question about pharo is welcome > Subject: Re: [Pharo-users] Automation of MS Office from Pharo > > > > The install instructions are not the same for Pharo 7, or

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

2020-04-05 Thread PBKResearch
s again Peter Kenny -Original Message- From: Pharo-users 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 mailto:pharo-users@lists.pharo.org> >

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

2020-04-05 Thread teso...@gmail.com
nshot of the error stack when I try to run the testWord case >> in PharoCOM-Tests. >> >> Thanks again >> >> Peter Kenny >> >> -Original Message- >> From: Pharo-users On Behalf Of >> teso...@gmail.com >> Sent: 05 April 2020 1

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

2020-04-05 Thread teso...@gmail.com
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 On Behalf Of > teso...@gmail.com > Sent: 05 April

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

2020-04-05 Thread teso...@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