G
gildo4realdo
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 tha
whenever I enter in information into the template, it creates a copy i
both excel databases.
I could just create a new duplicate database and a duplicate templat
but that would require me entering in the information twice. Since
enter in a lot of information, this is very undesirable.
Anyone please help me figure out how to link one template (.xlt) to
excel database files (.xls)
Steps already taken:
When the template wizard asked for a destination database, I even trie
putting in two file names separated by a ; but this just makes one fil
named (whatever; whatever.xls) so any other suggestions would be ver
welcome. I tried looking into the visual basic editor but the templat
file doesn't make the code it uses to link to the database available i
visual basic for the user to edit so I also drew a blank here
that works fine. Now I want to create a second database so tha
whenever I enter in information into the template, it creates a copy i
both excel databases.
I could just create a new duplicate database and a duplicate templat
but that would require me entering in the information twice. Since
enter in a lot of information, this is very undesirable.
Anyone please help me figure out how to link one template (.xlt) to
excel database files (.xls)
Steps already taken:
When the template wizard asked for a destination database, I even trie
putting in two file names separated by a ; but this just makes one fil
named (whatever; whatever.xls) so any other suggestions would be ver
welcome. I tried looking into the visual basic editor but the templat
file doesn't make the code it uses to link to the database available i
visual basic for the user to edit so I also drew a blank here