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