× 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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.