Help With CF and XLS files

Hey all,

This is my first time posting here. Normally I just search google to death for an answer to my problem but this one is stumping me.

I have a page that dynamically creates an XLS output for a customer. However what I need it to do, is create the XLS file, save it on the server (not display it) and then attach it in an email using CFMAIL. I know "how" to create the XLS, I know "how" to add attachments in CFMail. What I am having a difficult time with is saving the XLS "FOR" attaching the file.

I'm running into two problems.. one is that im not sure how to save files on the server in this manner, and two im concerned with the fact that if two or more users are using the application at the same time, they aren't going to get the correct output.

Can anyone offer any advice on this one? Thanks.

Derek

Well i found part of my answer via the search function here:

http://forums.devshed.com/t144803/s.html&highlight=excel

However that still leaves the problem of reports possibly getting duplicated. I tried using a variable to save the report name, and then just attach the file based on the variable but for some reason the variable is causing a cf error. And i do have <cfoutput> around it so i know that is not the issue.


Derek

Without seeing the code it is impossible to judge the problem. Are you saving an illegal file name?