Tim,

Thanks for your reply. Your method works well. I successfully called out the
dialog box. But I would like to automate two more steps to complete the
transfer of data to iSeries. After the dialog box came out, I have to do two
things:

1. I have to click "Browse" to browse for the predefined Request template
file I made before to use it to connect to the iSeries.

2. I have to click "OK" to run the transfer.

Is there any way for me to pass parameters to automate these two steps so
that the user don't have to do anything for each request??

Thanks,
Leslie

"Tim Williams" wrote:

If the iSeries commands are on a toolbar you should be able to see the names
of the routines called by right-clicking anywhere on a toolbar and choosing
"customize". Then right-click on the iSeries button in question and see if
there is an "assign macro" option: this should give you a name you can use
in an "Application.Run..." call after you've selected each range.

Tim

--
Tim Williams
Palo Alto, CA


"Leslie" wrote in message
...
Bob,

Thanks for your reply. I tried to use the Macro recorder before. But it
didn't work out correctly. It only recorded down the first step of data
range
selectioin I performed. For the next step, click "Data"-"Transfer Data To
iSeries", it had nothing mentioned about it. I wonder if it is because the
Macro recorder cannot record procedures that involves the use of add-in
features. I'm trying to see if I could get this done by manual coding. But
the thing is I even couldn't see the add-in in the Object Browser.

Thanks,
Leslie

"Bob Phillips" wrote:

Try turning on the macro recorder and do the steps manually, turn it off
and see what code you have.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Leslie" wrote in message
...
I have installed an add-in for the transfer of data from my excel data
to
iSeries. Every time I upload the data to iSeries, I have to select the
data
range on the sheet and click "Data"-"Transfer Data To iSeries". As I
have
several tables of data needed to upload in the sheet, I have to
perform
the
this procedure repeatedly. In order to save time, I'm trying to make
use
of
Macros to create a button with lines of code which automatically
perform
the
above action when I press the button. However, I'm not that familiar
with
Excel Macro, I just couldn't find the add-in in the Object Browser and
I
don't know the exact syntax to perform this function.
Can anybody help??

Thanks,
Leslie