Attributes to run a vbs silently to open/save as csv/close excel without prompting the users with SAVE/CANCEL questions?

Posted on 2011-10-27
Last Modified: 2012-05-12
I have a script that silently opens and excel spreadsheet and saves it as a csv file but it keeps prompting the user with SAVE or CANCEL questions since there are several worksheets on the spreadsheet.  Is there an attribute that can be set that answers these questions silently so the user is not prompted?
Question by:talahi
    LVL 12

    Expert Comment

    can you post the script?
    LVL 92

    Accepted Solution

    Use a line like this, assuming your Excel application variable is something like xlApp:

    xlApp.DisplayAlerts = False

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now