Hi.
i've used the Template Wizard to create and link my workbook to a database, but i don't know how to transfer my data from my template to the database. I've read the help file but it just vaguely says that i have to save the template, but this does nothing to the database. could you tell me how to do this on excel 2000 and 2002?? cos i'm working on a project both at home and at college. On 2000 i've loaded up the Invoice template you get with it, and it has this macro on it that brings up the dialog box that i need for the transfer. how do i get this up?? I can't view the macro for some reason!!!!
thanks in advance
sivart
i've used the Template Wizard to create and link my workbook to a database, but i don't know how to transfer my data from my template to the database. I've read the help file but it just vaguely says that i have to save the template, but this does nothing to the database. could you tell me how to do this on excel 2000 and 2002?? cos i'm working on a project both at home and at college. On 2000 i've loaded up the Invoice template you get with it, and it has this macro on it that brings up the dialog box that i need for the transfer. how do i get this up?? I can't view the macro for some reason!!!!
thanks in advance
sivart