I finally found a way to get it to work. I tested this with Procomm 4.7 and Excel 97, on Windows 95 and also NT 4.0:
proc OpenExcel
; To start Excel without a file name:
dos "start excel" HIDDEN
; To load a file into an already open Excel
; (if Excel is not running, it...
knob,
Thank you for your help.
At work, all machines have Excel 97 (as a part of Office 97), Windows NT 4.0 with SP6a and Procomm 4.7.
run "excel.exe" does not work on any of the four machines I tried.
Yes, the Excel file is always in the same place (on a network drive), but I...
I stand corrected... I tried 'run "excel.exe"' at home and it worked, no path provided. At home, I have Windows XP and Office 2000. At work, I have Windows NT 4 and Office 97 and the above command does nothing at all. Hmmm...
I'm afraid it doesn't work, Hank! Your code only works if the DOS PATH variable includes the path to excel.exe or if you start the script from the directory where excel.exe lives.
Obviously I tried this before posting the first time. The solution will not be an obvious one, I'm afraid.
If you really need more than 9 COM ports and you can't get the hack to work, I suggest you use a COM port switch (matrix) that you can control via.. of course, a COM port!
This way you can live with only 2 COM ports: one connected to the matrix, from where it will be switched to your various...
Thank you all for your input! But... it doesn't work :(
Knob, my PATH does not include MS-Office information (the Office installer does not add it), so the Aspect command 'run "excel.exe"' won't work. I cannot/will not add anything to the PATH to make my script work. It has to run on...
I was wondering if any of you guys can tell me how to open Excel from an Aspect script without hard-coding the path to Excel.exe in the argument to the run command. The script needs to run on several machines which do not necessarily have Excel in the same directory.
Thanks a lot.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.