Hi All,
Briefly the problem is as follows, I have a report that exports to excel. We output the data to a CSV file and then import this file into excel. All works well but in some cases we have to uniquely name the CSV file to allow the same report to be ran at the same time on the server. This results in lots of files building up in the directory... The reason I can't simply remove this file after exporting to excel is the 'refresh' option in excel requires the CSV to still be there.
So my question is can I programmatically disable the refresh option, or any other option for that matter.
I'm using openedge 10.2b and excel 2007, but would obviously like it to work with all version of excel.....
Many thanks
Briefly the problem is as follows, I have a report that exports to excel. We output the data to a CSV file and then import this file into excel. All works well but in some cases we have to uniquely name the CSV file to allow the same report to be ran at the same time on the server. This results in lots of files building up in the directory... The reason I can't simply remove this file after exporting to excel is the 'refresh' option in excel requires the CSV to still be there.
So my question is can I programmatically disable the refresh option, or any other option for that matter.
I'm using openedge 10.2b and excel 2007, but would obviously like it to work with all version of excel.....
Many thanks