Running DOS .bat file from Shell in a small vs. full window

J

Jeff Manning

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DOS..BAT file problem from VB 1
Running Batch File from within Excel 5
Passing parameters from DOS shell to a word macro 1
Running a Batch file from VBA 6
Running a BAT file with Access 5
Using a "SHELL" Command 10
batch file to ftp code not running - please help! 0
using write #1 to create a batch file 2

Top