RESUME.XLW : Exporting to Excel

[msuryadarma]

Hi everyone,

I have VSFlexGrid on my application that shows data from a database. I have a function to save the content of the grid into Excel format.

Everything works fine, except everytime I want to export, it tells me that RESUME.XLW already exists, and if I want to rewrite it. I have to say Yes to make the exporting process successful. Now I realize that RESUME.XLW is probably the temporary file for the data before it's saved in excel format.

Now the question is, how do I make that question not appear? The one whether I want to rewrite RESUME.XLW. I want that file to be deleted automatically, or at least not ask and automatically rewrite it. Any ideas? Thanks in advance!

[alex_read]

Excel.application.displayalerts = false

Excel won't prompt you for any changes, but will just do as it's told (if only women were more like that! )

You need a referencce to the Excel library as you're probably aware - Project Menu > References > Microsoft Excel 9.0 Library etc.

[msuryadarma]

Alex,

Thanks a lot for the tip. It does exactly what I wanted.