>I think the best way is to open a second instance of XL and add an empty workbook. Then cut and paste and close your 1st one.
Thanks. Did you ever do something like this? The reason I ask is that I am not sure whether I am, perhaps, taking the wrong approach in the first place (the principle being: "ask the wrong question, and you might get the wrong answer").
The users do want to have the data in Excel (for possible later processing), and they dislike having to specify a filename when saving the "report" - perhaps they don't want to save the report after all.
I understand I can also copy from a DBF or cursor (this is the origin) directly to the Clipboard, but then I have some formatting problems - mainly, some of our articles (shoes) have codes like "0012345"; in this case, the zeroes disappear.
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)