Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need Help from someone with ASPExec Experience

Status
Not open for further replies.

dlingo

Programmer
Nov 19, 2001
60
US
I have downloaded the zip file for ASPExec from What I'm trying to do is execute a Visual Basic 5.0 Standard .exe from ASP, using VBScript.

The .exe file is named ouputExcel.exe and is located on the server side. The executable takes an Access table and exports it into Excel. All I need to do is execute the .exe file on the client and save the output on the client. I want the exported Excel file to be saved on the client side as Statistical Export.xls.

I have installed and registered the ASPExec.dll file on both the client and the server. I have also set up the World Wide Web Publishing service to interact with the desktop (on the server).

Here's my code:

ASPExecExcel.asp:

<html>
<head><title>Export Table into Excel</title></head>
<body bgcolor=white text=black>
<blockqoute>

<%
Set Executor = Server.CreateObject(&quot;ASPExec.Execute&quot;)
Executor.Application = &quot;C:\Inetpub\ 'server side extension of file
Executor.Parameters = &quot;C:\autoexec.bat&quot;
Executor.ShowWindow = True

Response.Write &quot;Attempting to execute &quot; & Executor.Application & &quot;<br>&quot;
strResult = Executor.ExecuteWinApp
Response.Write &quot;The Result of this call was: &quot; & strResult
%>

</blockquote>
</body>
</html>

When I run the ASP page my message is:
The Result of this call was: OK

However, I am unsuccessful in creating the spreadsheet file on the client side (but, if I run outputExcel.exe on the client side manually this is done successfully) and when I open Task Manager, outputExcel.exe never runs.

Please help....Thanks in advance..
 
I recall having problems like that.
Can you launch Notepad? I had to messing with the settings something about interaction with the desktop, I think.....

Also there is an example that is in the zip. it has
some suggestions for getting things to work.

hth
Corey
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top