Re: Automating downloading an Excel spread sheet to the series using a macro

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Rene,

Sounds like you've already done the hard part.


Just add the RUNRMTCMD command to the end of your macro, such as


RUNRMTCMD  CMD('CALL PGM(LIB/PGM)') RMTLOCNAME('10.0.0.4' *IP) +
RMTUSER(JERRY) RMTPWD(PASSWORD)                                       


The i5 program specified in the command would, then, kick in to do its 
thing.  That is, basically the steps that you say that you're signing on 
to the i5 to initiate.



        * Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Chavez, Rene (NBC Universal) wrote:

> I'm sorry I wasn't clear.
> I would like to code this process.
> Starting with a preformatted Excel spread sheet that I would design for the 
> users.
> Once the users have finished entering they would initiate a macro that would 
> save the sheet in .csv format.
> The saved sheet would be saved to an IFS folder, then the macro would initiate an iSeries job to 
> process the downloaded data.
> Currently, the macro I have created does save the spread sheet in .csv format 
> to an IFS folder.
> I then sign on to the iSeries to initiate the processing.
> My request deals with adding the saving of the spread sheet & connecting to the iSeries via ODBC 
> then initiating the iSeries job.
>
> I hope this explanation clears thing up.
>
> Thank you for your interest,   Rene