Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
gildo4realdo
 
Posts: n/a
Default Need One Excel Template to copy to TWO Databases


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WANTED: Excel template for loan payment record with random/irregular payments cassidy Excel Discussion (Misc queries) 1 July 24th 05 01:09 AM
how do I change an excel template into a "workbook" joyce Excel Discussion (Misc queries) 5 April 14th 05 04:38 PM
How to copy toolbar settings from Excel 2003? VJ Excel Discussion (Misc queries) 5 April 8th 05 09:53 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 03:04 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 11th 05 12:05 AM


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"