How to close one excel sheet out of multiple excel sheets using windows batch file

Question

0.00/5 (No votes)

See more:

I have multiple excel sheets opened in my windows system. I want to close a specific excel sheet using windows batch file.

Could you please help me with this.

What I have tried:

I have tried to close "Expenses.xlsx" excel sheet using the below command.

TASKKILL /FI "WINDOWTITLE eq Expenses - Excel" /f

But it's closing all the opened excel sheets, I want to close only one specific file out of multiple opened excel files.

Posted 16-Jul-19 22:02pm

nsvrao

Updated 18-Jul-19 6:15am

Add a Solution

Comments

CHill60 17-Jul-19 4:12am

You would have to have them open in separate instances of Excel.

nsvrao 17-Jul-19 4:54am

yes, all the excel files are separate instances. I want to close one instance via a batch file.

CHill60 17-Jul-19 5:10am

If your taskkill closed them all then they are not in separate instances of Excel - just multiple windows from the same instance

ZurdoDev 17-Jul-19 8:08am

1. They are called workbooks, not sheets. Sheets are inside of a workbook so start by using the correct terminology and then you'll be able to find answers online.
2. What version of Excel? Older versions only supported a single instance. Start by looking in task manager to see if there are multiple instances of Excel or not.

nsvrao 18-Jul-19 1:56am

Excel 2016... There are no multiple instances. Under one excel instance, multiple child processes are running.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2019-07-18T06:16:00

I doubt you'll find a way to do this from the command-line without using third-party tools. But if you're open to using an executable, you can write one yourself fairly easily. For example:

C#

using System;
using System.Runtime.InteropServices;

static class Program
{
    static void Main(params string[] args)
    {
        try
        {
            dynamic excel = Marshal.GetActiveObject("Excel.Application");
            dynamic workbooks = excel.Workbooks;
            foreach (string sheetName in args)
            {
                try
                {
                    dynamic workbook = workbooks[sheetName];
                    workbook.Close(false);
                }
                catch (COMException)
                {
                    Console.WriteLine("The workbook '{0}' is not open.", sheetName);
                }
            }
        }
        catch (COMException)
        {
            Console.WriteLine("Excel is not running.");
        }
    }
}