×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Not knowing much about scripting Excel, I searched the web on how to script excel to csv. The first example worked well, from my windows 7 desktop with Excel 2010 installed. But when running via RUNRMTCMD, failed. The fifth script was very long and involved as it did a lot more than I wanted, but it had those two lines of code.
Thank you all for your help and I hope this tread helps others in the future.
Chris Bipes
Director of Information Services
CrossCheck, Inc.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Yeung
Sent: Monday, November 10, 2014 1:49 PM
To: Midrange Systems Technical Discussion
Subject: Re: RUNRMTCMD
On Mon, Nov 10, 2014 at 4:24 PM, Chris Bipes
<chris.bipes@xxxxxxxxxxxxxxx> wrote:
I have got the script working.
The two lines I added to get it working are:
oExcel.Visible = False
oExcel.DisplayAlerts = False
This is precisely what I was getting at when I said the script most
likely doesn't display the Excel GUI. Excel *isn't* necessarily
interactive. I thought you had already turned visibility off.
midrange.com
