Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I send excel worksheet to QuickBooks Pro? | Excel Worksheet Functions | |||
Can't send data from form to spreadsheet. | Excel Discussion (Misc queries) | |||
send document from Excel to Word in readable form | Excel Discussion (Misc queries) | |||
Form to send by Email | Excel Discussion (Misc queries) | |||
I only want to send one worksheet from excel not the all the work. | Excel Discussion (Misc queries) |