Excel Template

A

Atif Hasan

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
 
R

Ron de Bruin

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
 
G

Gord Dibben

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
 
R

Ron de Bruin

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>
 
G

Gord Dibben

I get a lot of requests by email since I am on record as having a good copy
of the Wizard.


Gord
 
A

Atif Hasan

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.
 
G

Gord Dibben

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
 
A

Atif Hasan

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
 
G

Gord Dibben

In Step 2 the only choice I get for database is Microsoft Excel Workbook.

Cannot help you with the Access issue.


Gord
 
A

Atif Hasan

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
 
G

Gord Dibben

Cool.

Might be your ODBC sources are configured differently from mine.

I will investigate.


Gord
 
J

Jarrett Lambert

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 i
Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machin

-

Regards Ron de Brui
http://www.rondebruin.nl/tips.htm

Previous Posts In This Thread:

Excel Template
I was using Office 2003 before, and in excel 2003 i have created one invoic
template and connected it with my access data base, before it was done ver
simple method by using Template wizard, i connect the desired Excell Shee
Cell with my Access Data Base table Field, but now when i have upgraded t
Office 2007, the link is not working, i am not able to connect my excel shee
cell data with the access database filed, no idea what to do, is there an
Template Wizard for office 2007 as it was in office 2003
Plz response, and thanks in Advanc
-
Atif Hasan

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 i
Or if you have a other machine where you use this add-in (WZTEMPLT.XLA) you can copy it to the new machin

-

Regards Ron de Brui
http://www.rondebruin.nl/tips.htm

RonI will confirm the Template Wizard works in 2007..........
Ro

I will confirm the Template Wizard works in 2007..........but limited t
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 databas

Gor

wrote:

Hi GordThanks for helping in this threadI never used it Gord so I cannot help
Hi Gor

Thanks for helping in this threa

I never used it Gord so I cannot help yo

I only send a thousand times or so to Excel users with 2003 that where not abl
to install it. Now that I reply in this thread I will keep the file on my desktop so
can reply fast with the file if newsgroup readers want it <vbg

-

Regards Ron de Brui
http://www.rondebruin.nl/tips.htm

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 cop
of the Wizard

Gor

wrote:

Hi GordGood to hear that I am not the only one--Regards Ron de Bruinhttp://www.
Hi Gor

Good to hear that I am not the only on

-

Regards Ron de Brui
http://www.rondebruin.nl/tips.htm

Thanks for your tipsI have installed 2002 Template Wizard and it worked for me
Thanks for your tip
I have installed 2002 Template Wizard and it worked for me on 200
now i am able to connect my excel 2007 cells to my access database as i wa
doing in 2003 before

-
Atif Hasa

:

AtifCan you walk me through the steps to create an Access Database using
Ati

Can you walk me through the steps to create an Access Database using th
Excel Template Wizard with Data Tracking

Gord Dibben MS Excel MVP

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


:

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

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


:

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/tutorial...90ab-50e54bcbc010/aspnet-applicationpage.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top