LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Reh Reh is offline
external usenet poster
 
Posts: 4
Default Problems running a dos program from vba script

Hello all, I'm new to the group so I hope this isn't too redundant of a

question.
I'm encountering a problem when attempting to call an external program
from an Excel macro. The macro runs through a variety of formatting
routines and then saves the file in .prn format to pass to the dos
program (this program generates a fish population estimate and is
unfortunately, to complex to simply write within the code.) I'm at the
point where I need to call up the program. I used the shell procedure
to access the dos program .exe file. It does access the program (I can
see the start screen flash) but then closes out. I tried writing a
batch file and accessing that from the macro..same result. The only
time I could get it to work, is when the batch file was misdirected
(another story) and had to search for the execution file. It found the
file (or rather a copy of it in another directory) and things worked
fine from there. Any thoughts?
thanks in advance..
-Chris.

note: I posted this in the excel vba group as well, but that group
seems to have low activity,
my appoligies for any inconvience caused by the crossposting.

 
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
script to launch a program from excel calvin Excel Discussion (Misc queries) 4 January 29th 09 09:12 PM
running script when workbook opens problems rich Excel Programming 0 November 3rd 06 08:05 PM
I have a kind of complex macro or vb script I want to program but do not know? bjwoodruff Excel Programming 4 June 14th 05 10:35 PM
how do i program a vb script in excel to tell me which cell has f. ragnarok Excel Programming 1 April 5th 05 06:27 PM
running vbs script from vba? John Gunn Excel Programming 1 November 13th 04 01:08 AM


All times are GMT +1. The time now is 08:55 PM.

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"