[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

[RobDog888]

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...

[l33t_c0w]

wow.. that was easy.

Thanks for the help again

[RobDog888]

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