t;" Months ""),"""")(DATEDIF(" & sText &
",""md""),IF(DATEDIF(" & sText & ",""md"")=1,""1 Day "",DATEDIF(" & sText
& " ,""md"")&
ase enter Date Cells Example D2,D1:") rem
------dim
args1(0) as new com.sun.star.beans.PropertyValueargs1(0).Name =
"StringName"args1(0).Value = "=IF(DATEDIF(" & sText & ",""y""),IF
12)=1,_1
Month _,MOD(DATEDIF(A2,A1,_m_),12)_ Months
_),__)IF(DATEDIF(A2,A1,_md_),IF(DATEDIF(A2,A1,_md_)=1,_1 Day
_,DATEDIF(A2,A1,_md_)_ Days_),__),A2,A1,chr$(34)sTextchr$(34)),_,CHAR(34))
dispatcher.executeDispatch(document,.uno:EnterString,, 0, args1())
msgbox (To complete process,+chr$(13)+Formula
Might I ask what you want the macro to do? Your macro confuses me a bit...
That said, the actual API has a very harsh learning curve (in my opinion). If I
rip apart what I see, I would guess the following:
The user enters some text, which represents a set of cells separated by a
comma.
to press 4 or 6 additional key strokes??
On 5 Jul 2020 at 1:33, Regina Henschel wrote:
Subject:Re: [libreoffice-users] Confused with Macro
results??
To:users@global.libreoffice.org
From:Regina henschelrb.hensc...@t-online.de
Date sent:Sun, 5 Jul 2020 01:33:10 +0200
Hi Michael,
your post
Subject:Re: [libreoffice-users] Confused with Macro
results??
Might I ask what you want the macro to do? Your macro confuses me a bit...
That said, the actual API has a very harsh learning curve (in my opinion). If I
rip apart what I see,
I would guess the following:
The user enters some text
Been doing a lot of googling, but finding lots of stuff, but nothing that works?
Have done a lot of versions and this is the latest one.
The record process does not allow for the use of the F2 key, so as is, it
results in the original args1(0).Value being in the cell?
After the macro ends, I've
Hi Michael,
your post is hard to understand. Please write, what you want to achieve
with your macro.
Kind regards
Regina
Michael D. Setzer II schrieb am 05-Jul-20 um 00:30:
Been doing a lot of googling, but finding lots of stuff, but nothing that works?
Have done a lot of versions and this