[Resolved] copy a file without saving

[l33t_c0w]

Is there a way, using Automation with Excel, to open a workbook, and then disassociate the workbook from the file it came from? Maybe it'd work to just change the workbook name, if that's possible.

What I want to do is, open a file multiple times, pasting different sets of data to it, without saving it. The opened files are meant to be used and saved by users as they see fit, and I don't want there to be anything "invisible" happening that they'd have to bother with, such as excel files lying around.

Right now a dialog comes up on all the files after the first informing the user that they can only have one version of the workbook open at once.

Thanks