Heeelp! I am stuck heavily!! I have this big obstacle that it seems impossible to resolve and it also seems there is no solution behind it!! It may seem easy at first glance but it is the most challenging obstacle in programming history. How can I save a file in excel, display it in crystal report, close the crystal report and save the file again? I know this may seem to be a beginners question but it is in fact an advanced question. The reason is, because when you save a file in excel using C# and display it in the crystal report, you cannot save the file again..because the file is in use and no matter what you do to close the file you cannot close the file...it is impossible to achieve...or at least it is impossible for me. Plese anyone can help me it would be greatly appreciate it. I have the entire project with source code attached here to try it out yourself. See what I mean?
If you want me to send you the source code please give me your email address and I will email it to you immediately.

1 answers
I don't need the entire project (nor am I willing to go through it to find the problem), simply post the relevant code here. If your application has an open file-handle to the file somewhere, all you need to do is find it, and close it. Please post the part of your code that displays the excel-file in Crystal Reports.
answered one year ago by:
2499