Hi everybody:
I have an issue when generating excel files from an ASP page
with Office 2000.
I'm using the following code to do so but apparently there's an error when
opening an existing file:
*****************************************************
Activex Component Can't Create Object "Excel.Sheet"
*****************************************************
This is the code:
*************************************************************
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
cPath = Request.ServerVariables("PATH_TRANSLATED")
While (Right(cPath, 1) <> "\" And Len(cPath) <> 0)
iLen = Len(cPath) - 1
cPath = Left(cPath, iLen)
Wend
' File
cPath1 = cPath & "downloads\"
' Define Objeto Excel
Set ExcelFace = CreateObject("Excel.Sheet")
' Not visible for the user
ExcelFace.Application.Visible =true
' Open work file
cFileName1 = "DOA001351398088076.xls"
Response.Write("ruta:" & cPath1 + cFileName1)
ExcelFace.Application.Workbooks.Open (cPath1 + cFileName1)
ExcelFace.Application.ActiveWorkbook.Save
ExcelFace.Application.Quit
Set ExcelFace = Nothing
%>
<P> </P>
</BODY>
</HTML>
******************************************************************
This code was working very good with ofiice 97. Is there a tip i have to
use?
thanks in advance,
Luis Urcia
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
