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.


--
gildo4realdo
------------------------------------------------------------------------
gildo4realdo's Profile: http://www.excelforum.com/member.php...o&userid=25715
View this thread: http://www.excelforum.com/showthread...hreadid=391297