Problem saving workbook - ExcelRpt

[MatGIL]

Hi everyone,

I have a problem with Excel during my internship.

I do some measurement (1/2/10/721/12543.......). I have to copy the data in Excel to get the max of it.

However, before it, I have to copy the frequency and the span in 2 differents cells (not a problem).

When I open Excel, copy freq and span, my measurement is too long (from 0.1 sec to 7/8 sec). I found a way: open Excel, copy freq and span, save workbook, close it and re-open it after.

However, I would like to save the new Excel file with the same name without the dialog box because it save "copie......"

Is there a way to open the last file closed ?

I hope that my message is clear,

Matthieu

[SebastienF]

Hello,

For me is not clear. Can you give the part of your code you are speaking about ?

I don't think you can open the last closed file but there may be another solution.

Best regards