View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Manning Jeff Manning is offline
external usenet poster
 
Posts: 1
Default 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