Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LINKING A WORKSHEET TO AN AS/400
Hi,
I am using Excel 2002 with windows XP and I am looking for help on how to link a worksheet to an AS/400. I want to use a a command button to extract information based on a cell value and place it two cells to the right. Cell value returned value A1 99999 C1 If you need me to elaborate more please let me know. Thanks for your help. POIT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
LINKING A WORKSHEET TO AN AS/400
Jaime.
1. Dont SCREAM by using capitals. 2. Depends on the software running on the AS400 :) Probably you're meaning a standard database like DB2, in which case you'd need to verify that you have (a recent set) of the correct ODBC drivers. Contact your system admin or software vendor if you're not sure. Then you can use Data Query from the user interface or progam with VBA (using DAO/ADO) to your heart's delight. If it's proprietery software check to see if they have excel addin modules. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "POIT" wrote: Hi, I am using Excel 2002 with windows XP and I am looking for help on how to link a worksheet to an AS/400. I want to use a a command button to extract information based on a cell value and place it two cells to the right. Cell value returned value A1 99999 C1 If you need me to elaborate more please let me know. Thanks for your help. POIT |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
LINKING A WORKSHEET TO AN AS/400
-----Original Message----- Jaime. 1. Dont SCREAM by using capitals. 2. Depends on the software running on the AS400 :) Probably you're meaning a standard database like DB2, in which case you'd need to verify that you have (a recent set) of the correct ODBC drivers. Contact your system admin or software vendor if you're not sure. Then you can use Data Query from the user interface or progam with VBA (using DAO/ADO) to your heart's delight. If it's proprietery software check to see if they have excel addin modules. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "POIT" wrote: Hi, I am using Excel 2002 with windows XP and I am looking for help on how to link a worksheet to an AS/400. I want to use a a command button to extract information based on a cell value and place it two cells to the right. Cell value returned value A1 99999 C1 If you need me to elaborate more please let me know. Thanks for your help. POIT . Thanks for the info... Do you have any sample connections that I could look at? poit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a sales receipt worksheet to an inventory worksheet | Excel Worksheet Functions | |||
Linking Tab/worksheet names to a worksheet cell | Excel Discussion (Misc queries) | |||
can I name an excel worksheet tab by linking to worksheet data? | Excel Worksheet Functions | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Linking Formulas, Worksheet to Worksheet - Excel 2003 | Excel Discussion (Misc queries) |