Here's the problem:

Right now I have a one template (.xlt) and one excel database (.xls) that works fine. Now I want to create a second database so that whenever I enter in information into the template, it creates a copy in both excel databases.

I could just create a new duplicate database and a duplicate template but that would require me entering in the information twice. Since I enter in a lot of information, this is very undesirable.

Anyone please help me figure out how to link one template (.xlt) to 2 excel database files (.xls)

Steps already taken:

When the template wizard asked for a destination database, I even tried putting in two file names separated by a ; but this just makes one file named (whatever; whatever.xls) so any other suggestions would be very welcome. I tried looking into the visual basic editor but the template file doesn't make the code it uses to link to the database available in visual basic for the user to edit so I also drew a blank here.