Starting Excel from the System i

curryj

Well Known Member
Has anyone used RUNRMTCMD successfully to call a job on a Windows Server 2003 machine that starts Excel and opens a worksheet that contains an Auto_Open macro that does some processing, updates the spreadsheet, saves it, and exits Excel? We can run a simple batch file this way, but starting Excel presents some challenges.
 
You can start excel with a batch file with the following code. The file has automatice updates on open. You can write a VB script to save and close in the excel file.


echo off
start excel.exe C:\Aging.xls
 
Back
Top