|
Excel Template
I was using Office 2003 before, and in excel 2003 i have created one invoice
template and connected it with my access data base, before it was done very simple method by using Template wizard, i connect the desired Excell Sheet Cell with my Access Data Base table Field, but now when i have upgraded to Office 2007, the link is not working, i am not able to connect my excel sheet cell data with the access database filed, no idea what to do, is there any Template Wizard for office 2007 as it was in office 2003? Plz response, and thanks in Advance -- Atif Hasan |
Excel Template
The last version is for 2002 but It is working in 2003 also and I think in 2007.
The only problem is that the install file from the 2002 version is not working for 2003-2007. If you mail me private I can send you the 2002 xla file so you can install it Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machine -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Atif Hasan" wrote in message ... I was using Office 2003 before, and in excel 2003 i have created one invoice template and connected it with my access data base, before it was done very simple method by using Template wizard, i connect the desired Excell Sheet Cell with my Access Data Base table Field, but now when i have upgraded to Office 2007, the link is not working, i am not able to connect my excel sheet cell data with the access database filed, no idea what to do, is there any Template Wizard for office 2007 as it was in office 2003? Plz response, and thanks in Advance -- Atif Hasan |
Excel Template
Ron
I will confirm the Template Wizard works in 2007..........but limited to only 256 fields/columns. What I don't know if how to get it to write to an Access database. I get no option other than to write to Excel Workbook database Gord On Mon, 18 Jan 2010 21:13:17 +0100, "Ron de Bruin" wrote: The last version is for 2002 but It is working in 2003 also and I think in 2007. The only problem is that the install file from the 2002 version is not working for 2003-2007. If you mail me private I can send you the 2002 xla file so you can install it Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machine |
Excel Template
Hi Gord
Thanks for helping in this thread What I don't know if how to get it to write to an Access database. I never used it Gord so I can't help you I only send a thousand times or so to Excel users with 2003 that where not able to install it. Now that I reply in this thread I will keep the file on my desktop so I can reply fast with the file if newsgroup readers want it <vbg -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Ron I will confirm the Template Wizard works in 2007..........but limited to only 256 fields/columns. What I don't know if how to get it to write to an Access database. I get no option other than to write to Excel Workbook database Gord On Mon, 18 Jan 2010 21:13:17 +0100, "Ron de Bruin" wrote: The last version is for 2002 but It is working in 2003 also and I think in 2007. The only problem is that the install file from the 2002 version is not working for 2003-2007. If you mail me private I can send you the 2002 xla file so you can install it Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machine |
Excel Template
I get a lot of requests by email since I am on record as having a good copy
of the Wizard. Gord On Mon, 18 Jan 2010 22:50:46 +0100, "Ron de Bruin" wrote: Hi Gord Thanks for helping in this thread What I don't know if how to get it to write to an Access database. I never used it Gord so I can't help you I only send a thousand times or so to Excel users with 2003 that where not able to install it. Now that I reply in this thread I will keep the file on my desktop so I can reply fast with the file if newsgroup readers want it <vbg |
Excel Template
Hi Gord
I get a lot of requests by email since I am on record as having a good copy of the Wizard. Good to hear that I am not the only one -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I get a lot of requests by email since I am on record as having a good copy of the Wizard. Gord On Mon, 18 Jan 2010 22:50:46 +0100, "Ron de Bruin" wrote: Hi Gord Thanks for helping in this thread What I don't know if how to get it to write to an Access database. I never used it Gord so I can't help you I only send a thousand times or so to Excel users with 2003 that where not able to install it. Now that I reply in this thread I will keep the file on my desktop so I can reply fast with the file if newsgroup readers want it <vbg |
Excel Template
Thanks for your tips
I have installed 2002 Template Wizard and it worked for me on 2007 now i am able to connect my excel 2007 cells to my access database as i was doing in 2003 before. -- Atif Hasan "Atif Hasan" wrote: I was using Office 2003 before, and in excel 2003 i have created one invoice template and connected it with my access data base, before it was done very simple method by using Template wizard, i connect the desired Excell Sheet Cell with my Access Data Base table Field, but now when i have upgraded to Office 2007, the link is not working, i am not able to connect my excel sheet cell data with the access database filed, no idea what to do, is there any Template Wizard for office 2007 as it was in office 2003? Plz response, and thanks in Advance -- Atif Hasan |
Excel Template
Atif
Can you walk me through the steps to create an Access Database using the Excel Template Wizard with Data Tracking? Gord Dibben MS Excel MVP On Tue, 19 Jan 2010 04:19:01 -0800, Atif Hasan wrote: Thanks for your tips I have installed 2002 Template Wizard and it worked for me on 2007 now i am able to connect my excel 2007 cells to my access database as i was doing in 2003 before. |
Excel Template
i ran the template wizard, first it asked me the file name to be saved then
in the next step it asked me about the database in which i want to link the cell data after that it asked me to choose the table of that database then i selected the database table and linked the cells with my table, like in my excel sheet where i put date i linked it with the date field of my database and so on, but there is one problem now i am facing, my previous data base file extension was .MDB and in Access 2007 the file extension is .ACCDB and Template wizard is not recognizing that file even after i have convereted .ACCDB to .MDB format still it is not wokring. But working for the databse which was created in Access 2003. now can u help me in this regard -- Atif Hasan "Gord Dibben" wrote: Atif Can you walk me through the steps to create an Access Database using the Excel Template Wizard with Data Tracking? Gord Dibben MS Excel MVP On Tue, 19 Jan 2010 04:19:01 -0800, Atif Hasan wrote: Thanks for your tips I have installed 2002 Template Wizard and it worked for me on 2007 now i am able to connect my excel 2007 cells to my access database as i was doing in 2003 before. . |
Excel Template
In Step 2 the only choice I get for database is Microsoft Excel Workbook.
Cannot help you with the Access issue. Gord On Tue, 19 Jan 2010 21:13:02 -0800, Atif Hasan wrote: i ran the template wizard, first it asked me the file name to be saved then in the next step it asked me about the database in which i want to link the cell data after that it asked me to choose the table of that database then i selected the database table and linked the cells with my table, like in my excel sheet where i put date i linked it with the date field of my database and so on, but there is one problem now i am facing, my previous data base file extension was .MDB and in Access 2007 the file extension is .ACCDB and Template wizard is not recognizing that file even after i have convereted .ACCDB to .MDB format still it is not wokring. But working for the databse which was created in Access 2003. now can u help me in this regard |
Excel Template
In 2nd Step i have a drop down list, 1st option is Excel, 2nd is Access, 3rd
database II and 4th option is database III -- Atif Hasan "Gord Dibben" wrote: In Step 2 the only choice I get for database is Microsoft Excel Workbook. Cannot help you with the Access issue. Gord On Tue, 19 Jan 2010 21:13:02 -0800, Atif Hasan wrote: i ran the template wizard, first it asked me the file name to be saved then in the next step it asked me about the database in which i want to link the cell data after that it asked me to choose the table of that database then i selected the database table and linked the cells with my table, like in my excel sheet where i put date i linked it with the date field of my database and so on, but there is one problem now i am facing, my previous data base file extension was .MDB and in Access 2007 the file extension is .ACCDB and Template wizard is not recognizing that file even after i have convereted .ACCDB to .MDB format still it is not wokring. But working for the databse which was created in Access 2003. now can u help me in this regard . |
Excel Template
Cool.
Might be your ODBC sources are configured differently from mine. I will investigate. Gord On Wed, 20 Jan 2010 21:07:01 -0800, Atif Hasan wrote: In 2nd Step i have a drop down list, 1st option is Excel, 2nd is Access, 3rd database II and 4th option is database III |
Working Excel Template Manager File
I'm in need of a working excel template wizard add-in file. The report manager add-in would be helpful to if possible. How do I get in touch with one of you so I can get a copy? Or my email is jarrettDOTlambertATlaDOTgov
Thanks Ron de Bruin wrote: The last version is for 2002 but It is working in 2003 also and I think in 18-Jan-10 The last version is for 2002 but It is working in 2003 also and I think in 2007. The only problem is that the install file from the 2002 version is not working for 2003-2007. If you mail me private I can send you the 2002 xla file so you can install it Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machine -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm Previous Posts In This Thread: On Monday, January 18, 2010 4:20 AM Atif Hasan wrote: Excel Template I was using Office 2003 before, and in excel 2003 i have created one invoice template and connected it with my access data base, before it was done very simple method by using Template wizard, i connect the desired Excell Sheet Cell with my Access Data Base table Field, but now when i have upgraded to Office 2007, the link is not working, i am not able to connect my excel sheet cell data with the access database filed, no idea what to do, is there any Template Wizard for office 2007 as it was in office 2003? Plz response, and thanks in Advance -- Atif Hasan On Monday, January 18, 2010 3:13 PM Ron de Bruin wrote: The last version is for 2002 but It is working in 2003 also and I think in The last version is for 2002 but It is working in 2003 also and I think in 2007. The only problem is that the install file from the 2002 version is not working for 2003-2007. If you mail me private I can send you the 2002 xla file so you can install it Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machine -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm On Monday, January 18, 2010 4:34 PM Gord Dibben wrote: RonI will confirm the Template Wizard works in 2007.......... Ron I will confirm the Template Wizard works in 2007..........but limited to only 256 fields/columns. What I do not know if how to get it to write to an Access database. I get no option other than to write to Excel Workbook database Gord wrote: On Monday, January 18, 2010 4:50 PM Ron de Bruin wrote: Hi GordThanks for helping in this threadI never used it Gord so I cannot help Hi Gord Thanks for helping in this thread I never used it Gord so I cannot help you I only send a thousand times or so to Excel users with 2003 that where not able to install it. Now that I reply in this thread I will keep the file on my desktop so I can reply fast with the file if newsgroup readers want it <vbg -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm On Monday, January 18, 2010 5:42 PM Gord Dibben wrote: I get a lot of requests by email since I am on record as having a good copyof I get a lot of requests by email since I am on record as having a good copy of the Wizard. Gord wrote: On Monday, January 18, 2010 5:49 PM Ron de Bruin wrote: Hi GordGood to hear that I am not the only one--Regards Ron de Bruinhttp://www. Hi Gord Good to hear that I am not the only one -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm On Tuesday, January 19, 2010 7:19 AM Atif Hasan wrote: Thanks for your tipsI have installed 2002 Template Wizard and it worked for me Thanks for your tips I have installed 2002 Template Wizard and it worked for me on 2007 now i am able to connect my excel 2007 cells to my access database as i was doing in 2003 before. -- Atif Hasan "Atif Hasan" wrote: On Tuesday, January 19, 2010 11:05 AM Gord Dibben wrote: AtifCan you walk me through the steps to create an Access Database using Atif Can you walk me through the steps to create an Access Database using the Excel Template Wizard with Data Tracking? Gord Dibben MS Excel MVP On Wednesday, January 20, 2010 12:13 AM Atif Hasan wrote: i ran the template wizard, first it asked me the file name to be saved thenin i ran the template wizard, first it asked me the file name to be saved then in the next step it asked me about the database in which i want to link the cell data after that it asked me to choose the table of that database then i selected the database table and linked the cells with my table, like in my excel sheet where i put date i linked it with the date field of my database and so on, but there is one problem now i am facing, my previous data base file extension was .MDB and in Access 2007 the file extension is .ACCDB and Template wizard is not recognizing that file even after i have convereted .ACCDB to .MDB format still it is not wokring. But working for the databse which was created in Access 2003. now can u help me in this regard -- Atif Hasan "Gord Dibben" wrote: On Wednesday, January 20, 2010 12:22 PM Gord Dibben wrote: In Step 2 the only choice I get for database is Microsoft Excel Workbook. In Step 2 the only choice I get for database is Microsoft Excel Workbook. Cannot help you with the Access issue. Gord On Thursday, January 21, 2010 12:07 AM Atif Hasan wrote: In 2nd Step i have a drop down list, 1st option is Excel, 2nd is Access, In 2nd Step i have a drop down list, 1st option is Excel, 2nd is Access, 3rd database II and 4th option is database III -- Atif Hasan "Gord Dibben" wrote: On Thursday, January 21, 2010 11:31 AM Gord Dibben wrote: Cool.Might be your ODBC sources are configured differently from mine. Cool. Might be your ODBC sources are configured differently from mine. I will investigate. Gord Submitted via EggHeadCafe - Software Developer Portal of Choice ASP.NET Application-Page Lifecycle Redux http://www.eggheadcafe.com/tutorials...ationpage.aspx |
Working Excel Template Manager File
You can find my mail address on my site
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Jarrett Lambert" wrote in message ... I'm in need of a working excel template wizard add-in file. The report manager add-in would be helpful to if possible. How do I get in touch with one of you so I can get a copy? Or my email is jarrettDOTlambertATlaDOTgov Thanks Ron de Bruin wrote: The last version is for 2002 but It is working in 2003 also and I think in 18-Jan-10 The last version is for 2002 but It is working in 2003 also and I think in 2007. The only problem is that the install file from the 2002 version is not working for 2003-2007. If you mail me private I can send you the 2002 xla file so you can install it Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machine -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm Previous Posts In This Thread: On Monday, January 18, 2010 4:20 AM Atif Hasan wrote: Excel Template I was using Office 2003 before, and in excel 2003 i have created one invoice template and connected it with my access data base, before it was done very simple method by using Template wizard, i connect the desired Excell Sheet Cell with my Access Data Base table Field, but now when i have upgraded to Office 2007, the link is not working, i am not able to connect my excel sheet cell data with the access database filed, no idea what to do, is there any Template Wizard for office 2007 as it was in office 2003? Plz response, and thanks in Advance -- Atif Hasan On Monday, January 18, 2010 3:13 PM Ron de Bruin wrote: The last version is for 2002 but It is working in 2003 also and I think in The last version is for 2002 but It is working in 2003 also and I think in 2007. The only problem is that the install file from the 2002 version is not working for 2003-2007. If you mail me private I can send you the 2002 xla file so you can install it Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machine -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm On Monday, January 18, 2010 4:34 PM Gord Dibben wrote: RonI will confirm the Template Wizard works in 2007.......... Ron I will confirm the Template Wizard works in 2007..........but limited to only 256 fields/columns. What I do not know if how to get it to write to an Access database. I get no option other than to write to Excel Workbook database Gord wrote: On Monday, January 18, 2010 4:50 PM Ron de Bruin wrote: Hi GordThanks for helping in this threadI never used it Gord so I cannot help Hi Gord Thanks for helping in this thread I never used it Gord so I cannot help you I only send a thousand times or so to Excel users with 2003 that where not able to install it. Now that I reply in this thread I will keep the file on my desktop so I can reply fast with the file if newsgroup readers want it <vbg -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm On Monday, January 18, 2010 5:42 PM Gord Dibben wrote: I get a lot of requests by email since I am on record as having a good copyof I get a lot of requests by email since I am on record as having a good copy of the Wizard. Gord wrote: On Monday, January 18, 2010 5:49 PM Ron de Bruin wrote: Hi GordGood to hear that I am not the only one--Regards Ron de Bruinhttp://www. Hi Gord Good to hear that I am not the only one -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm On Tuesday, January 19, 2010 7:19 AM Atif Hasan wrote: Thanks for your tipsI have installed 2002 Template Wizard and it worked for me Thanks for your tips I have installed 2002 Template Wizard and it worked for me on 2007 now i am able to connect my excel 2007 cells to my access database as i was doing in 2003 before. -- Atif Hasan "Atif Hasan" wrote: On Tuesday, January 19, 2010 11:05 AM Gord Dibben wrote: AtifCan you walk me through the steps to create an Access Database using Atif Can you walk me through the steps to create an Access Database using the Excel Template Wizard with Data Tracking? Gord Dibben MS Excel MVP On Wednesday, January 20, 2010 12:13 AM Atif Hasan wrote: i ran the template wizard, first it asked me the file name to be saved thenin i ran the template wizard, first it asked me the file name to be saved then in the next step it asked me about the database in which i want to link the cell data after that it asked me to choose the table of that database then i selected the database table and linked the cells with my table, like in my excel sheet where i put date i linked it with the date field of my database and so on, but there is one problem now i am facing, my previous data base file extension was .MDB and in Access 2007 the file extension is .ACCDB and Template wizard is not recognizing that file even after i have convereted .ACCDB to .MDB format still it is not wokring. But working for the databse which was created in Access 2003. now can u help me in this regard -- Atif Hasan "Gord Dibben" wrote: On Wednesday, January 20, 2010 12:22 PM Gord Dibben wrote: In Step 2 the only choice I get for database is Microsoft Excel Workbook. In Step 2 the only choice I get for database is Microsoft Excel Workbook. Cannot help you with the Access issue. Gord On Thursday, January 21, 2010 12:07 AM Atif Hasan wrote: In 2nd Step i have a drop down list, 1st option is Excel, 2nd is Access, In 2nd Step i have a drop down list, 1st option is Excel, 2nd is Access, 3rd database II and 4th option is database III -- Atif Hasan "Gord Dibben" wrote: On Thursday, January 21, 2010 11:31 AM Gord Dibben wrote: Cool.Might be your ODBC sources are configured differently from mine. Cool. Might be your ODBC sources are configured differently from mine. I will investigate. Gord Submitted via EggHeadCafe - Software Developer Portal of Choice ASP.NET Application-Page Lifecycle Redux http://www.eggheadcafe.com/tutorials...ationpage.aspx |
| All times are GMT +1. The time now is 11:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com