+ Reply to Thread
Results 1 to 2 of 2

Running batch file

  1. #1
    Registered User
    Join Date
    03-20-2009
    Location
    Lithuania
    MS-Off Ver
    Excel 2013
    Posts
    99

    Running batch file

    Hi,

    I'm programming in excel, that after certain time (like 1 hour), excel runs batch file "name.bat", which runs another file "name.vbs". This file "name.vbs" is used as a message box with some certain information.

    However when excel runs "name.bat" file, first of all I see a black screen (MS DOS) and after it closes only then I see message box. Is it possible to write some command in batch file that no black screen would be shown, no MS DOS would be seen?
    Last edited by walduxas; 04-02-2009 at 09:13 AM.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Running batch file

    walduxas,

    Can you post your code using code tags?


    Batch file execution via VBA in MS EXCEL
    http://www.experts-exchange.com/Prog..._22781944.html

    Or, do a Google search for "Running batch file in excel vba".


    Have a great day,
    Stan
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1