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

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

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

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,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"riggi" wrote:

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

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

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



Gary L Brown wrote:
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,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"riggi" wrote:

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

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

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


--
protonLeah


------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=556066

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

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



riggi wrote:

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

--

Dave Peterson