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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel objects

Status
Not open for further replies.

sineados

Programmer
Oct 17, 2001
34
IE
Hi,

I have an asp page which opens an Excel object, fills out a spreadsheet, renames it and opens it in a new window. Works fine on all the machines except for one. It creates the excel spreadsheet but the window does not seem to open.

I have compared the Internet settings and they are the same on both machines. Is there something else I am missing. All machines have IE6 and Excel 2000 installed.

This is basically the lines of code
if STCommon_PrintPurchaseOrder () = true then %>
<SCRIPT>window.open (&quot;StShowReport.asp&quot;,null,&quot;height=400,width=750,status=yes,toolbar=yes,scrollbars=yes,menubar=yes,location=yes&quot;); </SCRIPT>
<% end if


It seems to be the window.open function which is failing. Anyone any ideas because I am stumped!!

thanks,

 
try starting the window.open on it's own line. and give it a name instead of &quot;null&quot;

<SCRIPT>
window.open (&quot;StShowReport.asp&quot;,&quot;myWin&quot;,&quot;height=400,width=750,status=yes,toolbar=yes,scrollbars=yes,menubar=yes,location=yes&quot;);
</SCRIPT>

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

fart.gif
 
I tried that and it made no difference. I get no new window or no error message. I can see the Excel file on the server so know its creating that.

thanks,
 
Try adding an alert() message to see if it displays... Something's up with the javascript...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

fart.gif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top