Another VB to Excel question

[honchung]

Hi all,

By using VB6 to export data to Excel worksheet, if I have error during exporting or if I did not save the Excel file when closing it, how can I clear the "memory" or "buffer" leftover on the computer. I always got "End Program" prompts and "Save Excel Workbook File?" questions when shutting down the computer.

 

[johnwm]

Try faq222-2244 for notes on general forum usage. Then try faq222-3383

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints