ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Running DOS .bat file from Shell in a small vs. full window (https://www.excelbanter.com/excel-programming/297109-running-dos-bat-file-shell-small-vs-full-window.html)

Jeff Manning

Running DOS .bat file from Shell in a small vs. full window
 
I'm running the following

Call Shell("DOS batch file", vbNormalFocus

It runs fine, but in a fully maximized window. If I use the vbMinimizedNoFocus setting, a DOS shell opens up in the task bar, but the program won't run until I maximize the shell from the taskbar

I'd like the program to run in a smaller window in the foreground, as it does if I just embed the batch file as an object in the spreadsheet. I can't use the embedded object method because my bank blocks .BAT files for viruses, but they need the info in the spreadsheet

Thank you in advance for your help

Jeff


All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com