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

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) +

        * 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