RE: RUNRMTCMD

I have got the script working. So if anyone needs to convert xls to csv and has System i Access remote command running, here is the script

if WScript.Arguments.Count < 2 Then
WScript.Echo "Error! Please specify the source path and the destination. Usage: XlsToCsv SourcePath.xls Destination.csv"
Wscript.Quit
End If
Dim oExcel
Set oExcel = CreateObject("Excel.Application")
oExcel.Visible = False
oExcel.DisplayAlerts = False
Dim oBook
Set oBook = oExcel.Workbooks.Open(Wscript.Arguments.Item(0))
oBook.SaveAs WScript.Arguments.Item(1), 6
oBook.Close False
oExcel.Quit
Wscript.Quit

The two lines I added to get it working are:
oExcel.Visible = False
oExcel.DisplayAlerts = False

You pass it two parms, source and destination.

Chris Bipes
Director of Information Services
CrossCheck, Inc.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kevin Passey
Sent: Monday, November 10, 2014 12:55 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: RUNRMTCMD

Hi Chris

This command does not work on win7 - I had to program around it using Java and data queues.

Microsoft broke it making the desktop more secure.