Send Form Results to Excel WorkSheet
 

I have created a fairly complex form in Access and want to convert it to a
Frontpage form if it is not to much trouble. If it is I will recreate in
FrontPage.

My second dilema is I want to send the form results to an Excel 2007
worksheet. I found instructions in the knowledge base for send to an Excel
2000 sheet but not for Excel 2007. My problem are the instructions starting
he
Insert menu, point to Name, and then click Define
Click Add, and then click OK
The task bar on Excel 2007 does not have these options to select.
Are there instructions to do this using Excel 2007?
Finally, will this run on a Linux server or do you need to have a Windows
server to use this functionality? Thanks for any help you can give me on
this.
Cindy

Send Form Results to Excel WorkSheet
 

I can't answer your other questions as I don't use Access or Linux; however,
you can find the equivalent of Name/Define (from versions prior to XL2007)
on the "Formulas" tab in the "Defined Names" panel... the item you want has
the caption "Define Name".

--
Rick (MVP - Excel)


"cjshaffer" wrote in message
...
I have created a fairly complex form in Access and want to convert it to a
Frontpage form if it is not to much trouble. If it is I will recreate in
FrontPage.

My second dilema is I want to send the form results to an Excel 2007
worksheet. I found instructions in the knowledge base for send to an
Excel
2000 sheet but not for Excel 2007. My problem are the instructions
starting
he
Insert menu, point to Name, and then click Define
Click Add, and then click OK
The task bar on Excel 2007 does not have these options to select.
Are there instructions to do this using Excel 2007?
Finally, will this run on a Linux server or do you need to have a Windows
server to use this functionality? Thanks for any help you can give me on
this.
Cindy

Send Form Results to Excel WorkSheet
 

Rick,
That moved me in the right direction. Thank you.
Cindy

"Rick Rothstein" wrote:

I can't answer your other questions as I don't use Access or Linux; however,
you can find the equivalent of Name/Define (from versions prior to XL2007)
on the "Formulas" tab in the "Defined Names" panel... the item you want has
the caption "Define Name".

--
Rick (MVP - Excel)


"cjshaffer" wrote in message
...
I have created a fairly complex form in Access and want to convert it to a
Frontpage form if it is not to much trouble. If it is I will recreate in
FrontPage.

My second dilema is I want to send the form results to an Excel 2007
worksheet. I found instructions in the knowledge base for send to an
Excel
2000 sheet but not for Excel 2007. My problem are the instructions
starting
he
Insert menu, point to Name, and then click Define
Click Add, and then click OK
The task bar on Excel 2007 does not have these options to select.
Are there instructions to do this using Excel 2007?
Finally, will this run on a Linux server or do you need to have a Windows
server to use this functionality? Thanks for any help you can give me on
this.
Cindy