Hi
I am using coldfusion 7 version and in my machine I have msoffice2007
with the earliar version of msoffice i.e. ‘2003’ the code was working fine without any error.
I have used this code to let the user open or download excel sheet.
<cffunction access=“public” name=“ExcelDownload” output=“true” returntype=“void”>
<cfargument name=“header” type=“string” required=“no”>
<cfargument name=“Filename” type=“string” required=“yes”>
<cfset var CRLF=chr(13)&chr(10)>
<cfcontent type=“application/vnd.msexcel”>
<cfheader name=“Content-Disposition” value=“attachment; filename=#Filename#”>
<cfif isDefined(‘header’)>
<cfoutput>#header##CRLF##CRLF#</cfoutput>
</cfif>
</cffunction>
when I try to download an excel file from the above cfm module it opens an excel sheet with an error message popped up which says:
“C:\<absolute local path>\Filename[1].xls” could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your most recently used files, make sure that the file has not been renamed, moved or deleted.
please help
Thanks