General information
Category:
COM/DCOM and 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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only