[Resolved] copy a file without saving

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

Create a xlt Template. using the EOM you can open the file in it over and over again since the template will append th file name with a 1, 2, 3,... Like Book1, Book2 Book3...

wow.. that was easy. :blush:

Thanks for the help again :)

NP, I started thinking of this in a complicated way and then it hit me so I know how you feel. ;) :)