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
|