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

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

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

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

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

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

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

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.

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.

.

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

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

.

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

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

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