I copied the code straight from Adobe's site and rewrote it using cfscript,
cfset, cfset temp =, cfset obj = and all of them threw the same error.
Variable SPREADSHEETREMOVESHEET is undefined.
Here is the various code I tried in CF 9:
<cfset spreadsheetRemoveSheet(Patient_Output,"newCalc_P1")>
<cfset temp = spreadsheetRemoveSheet(Patient_Output,"newCalc_P1")>
<cfset Patient_Output = spreadsheetRemoveSheet(Patient_Output,"newCalc_P1")>
<cfscript>
Patient_Output = spreadsheetRemoveSheet(Patient_Output,"newCalc_P1");
</cfscript>
I thought that with all the spreadsheet functionality that this project
would be fairly quick and need it tomorrow. I was trying to find a work
around for the duplicate sheet error in the last message I posted so
thought maybe if I deleted the sheet first and then saved it I would have a
work around and instead I just got another error message.
Help!!!
Thanks in advance for any and all help,
Jeff