>Hilmar,
>
>PMFJI, below is an extract from a class that does exactly this. Basically, the generated Excel sheet is copied using the Copy method and the original workbook is closed. In my case, I delete the temp file and leave it up to the user to save or discard the generated Excel file. If you want to keep the original file, simply comment the DELETE FILE line.
Great! I will try this tomorrow, at work - probably with a few minor modifications to fit my personal preferences. It seems to be precisely what I need.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)