Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Shell Jeff Excel Discussion (Misc queries) 0 January 28th 08 04:50 PM
How I can I open a small window within window Loz Excel Discussion (Misc queries) 0 May 20th 07 09:04 PM
Want to see ALL labels in small window Access Joe Charts and Charting in Excel 1 February 21st 07 08:57 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
Closing DOS window after shell command Garry Boswell Excel Programming 1 January 9th 04 10:32 PM


All times are GMT +1. The time now is 04:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"