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

2020-04-09 Thread Ben Coman
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
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, Tomaž T

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
ent: 8.4.2020 9:54:35 Subject: Re: [Pharo-users] Automation of MS Office from Pharo Hi!!! This was a great report. I have submitted a fix in the master of Pharo-COM. Basically the problem was to free twice the BSTR in the Variant. It was being free in the access to the value and in the free of th

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
in 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-08 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

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

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 down where the problem

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, because

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

2020-04-07 Thread Tomaž Turk
? 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; after a day of

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

2020-04-06 Thread PBKResearch
is 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]

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

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

2020-04-06 Thread Tomaž Turk
quot; 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 e

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

2020-04-05 Thread PBKResearch
: 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 some of your tests

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

2020-04-05 Thread PBKResearch
: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 saw the instruct

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
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> > Subject: Re: [P

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

2020-04-05 Thread teso...@gmail.com
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 16:23 >>

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

2020-04-05 Thread teso...@gmail.com
s 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 2020 16:23 >

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

[Pharo-users] Automation of MS Office from Pharo

2020-04-05 Thread PBKResearch
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