MS-dos and Excel .. please help !!!

R

riggi

Hi,
I used shell command to start a MS-Dos application, it worked fine.
But, when I enter the input file name for the application. The program
tells me that file not found!! ( The program looks for the file in the
same directory ). I have tried running the application directly from
that directory and it finds the file and runs absolutely fine. Its just
that when I ask excel to run the application and when I type in the
input file name, it won't find that file.
What I am thinking is that... excel might be first saving that
application in some temp folder and then running it from there. I don't
knwo if I am right or wrong. Please help.


Thanks,
Riggi
 
G

Gary L Brown

Don't know if this is your issue but remember that Dos uses 8 letter names so
Dos sees...
C:\MyFavoriteFiles\MyCurrentExcelFile.xls
as something like
C:\MyFavo~1\MyCurr~1.xls

HTH,
 
R

riggi

I don't think its the problem with DOS .. I guess its something with
excel.... cuz I can run the Dos program by doudle clicking it,and it
runs fine; but when I make excel to open it.. and then type in the
input fie name, it won't be able to find the file and returns .. file
not found!
Any ideas???

Thanks,

Riggi
 
P

protonLeah

You may have to set/modify the PATH environment variable. When you open
the DOS window, and before you load your DOS App, type "path" and check
to see if the drive\directory for your file is included. If it is not,
then type something like the following

path=%path%;X:\dir1\dir2

where X: is the drive, dir1, dir2, etc., are the folder/subfolder names
where the file is saved
 
D

Dave Peterson

Maybe you could start a .bat file that changes to that drive and then changes to
that folder and then starts the program.

c:
cd\yourfolder
yourprogramnamehere yourinputfilehere
 
Top