Hi Everybody,
my name is Dominik, I am new here and I need help
In the good old iSeries I had a macro which was switching to an Excel spreadsheet for me in the last step. I was using this macro to speed up a copy-paste data process from Excel to iSeries. Macros in iSeries were using a syntax similar to VBA so I was able to tailor them to my needs.
Now, in a java Access Client macros are in XML and I have no idea how to insert a command: "switch to excel spreadsheet" there.
Below I am pasting an "empty" macro in i Access so you know what I am talking about.
Can anybody help me write this command?
Thanks!
<HAScript name="nowe" description="" timeout="60000" pausetime="300" promptall="true" blockinput="true" author="Me" creationdate="2019-11-18 10:44:48" supressclearevents="false" usevars="false" ignorepauseforenhancedtn="true" delayifnotenhancedtn="0" ignorepausetimeforenhancedtn="true" continueontimeout="false">
<screen name="Screen1" entryscreen="true" exitscreen="true" transient="false">
<description >
<oia status="NOTINHIBITED" optional="false" invertmatch="false" />
</description>
<actions>
</actions>
<nextscreens timeout="0" >
</nextscreens>
</screen>
</HAScript>
my name is Dominik, I am new here and I need help

In the good old iSeries I had a macro which was switching to an Excel spreadsheet for me in the last step. I was using this macro to speed up a copy-paste data process from Excel to iSeries. Macros in iSeries were using a syntax similar to VBA so I was able to tailor them to my needs.
Now, in a java Access Client macros are in XML and I have no idea how to insert a command: "switch to excel spreadsheet" there.
Below I am pasting an "empty" macro in i Access so you know what I am talking about.
Can anybody help me write this command?
Thanks!
<HAScript name="nowe" description="" timeout="60000" pausetime="300" promptall="true" blockinput="true" author="Me" creationdate="2019-11-18 10:44:48" supressclearevents="false" usevars="false" ignorepauseforenhancedtn="true" delayifnotenhancedtn="0" ignorepausetimeforenhancedtn="true" continueontimeout="false">
<screen name="Screen1" entryscreen="true" exitscreen="true" transient="false">
<description >
<oia status="NOTINHIBITED" optional="false" invertmatch="false" />
</description>
<actions>
</actions>
<nextscreens timeout="0" >
</nextscreens>
</screen>
</HAScript>
Comment