Information générale
Catégorie:
COM/DCOM et OLE Automation
>>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.
I really haven't done this, but if your users are... mmm... lazy... then you can open the second empty file and do a 'save as' immediately (that should only take a fraction of a second). Then do the copy/paste and close your original file. That way they'll have a file in which they can just click 'save' without having to go through the horrible process of naming it, and it still won't overwrite yours.
I can't really think of a better way offhand.
Alan
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement