>>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.
>
If the sheets are not large, you might want to think about using Excel automation to populate and name the sheet for you; put the data into your XLS spreadsheet, open a new workbook using automation, and then copy the XLS (or DBF - Excel can read a DBF file) into the proper cells, or open the XLS you create using automation and then rename it via Save As before exposing it to the user to edit.