For those not already familiar this relates to my previous questions yesterday "VB 5 & MS Excel 97 - Process not releasing".
I am just going to follow on from there.
I think that I have identified why the Excel Process is not releasing but as of yet can not find a solution.
The code works fine if you open an Excel File, Save it and Close.
The Problem is introduced when you perform some formatting and layout changes to the Excel File.
As I am converting a CSV file to XLS and performming formatting and layout changes I get the Message box on saving notifying that this CSV was saved in a previsous version of excel - Do you want to save in 97, so on.
The problem is that I have yet not seen a way to answer yes to this and this seems to be what keeps the Excel process open.
If you leave DisplayAlerts = True and try modify a file of this format you will get the message box I am talking about and the Excel process should not release after you have set xlApp = nothing.
Any ideas on this one guys?
Thanks in advance for any help! It is very much appreciated as always!