Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic transfer AS400- Excel
Hello
I am trying to transfer data from an AS400 system to a Excel sheet, Now this is done manually by cliking the add-in from Client Access named CWBTFXLA.XLL This works but the data has to be formatted afterwards, I want to make the transfer automatic via VBA en then run some code on it. The formating code works but i can't get the automatic transfer to work. Pse help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic transfer AS400- Excel
"Warzel" wrote in message ... Hello I am trying to transfer data from an AS400 system to a Excel sheet, Now this is done manually by clicking the add-in from Client Access named CWBTFXLA.XLL This works but the data has to be formatted afterwards, I want to make the transfer automatic via VBA en then run some code on it. The formating code works but i can't get the automatic transfer to work. Pse help You should be able to set up an ODBC connection to the AS400 system. Having done that, you can get data by making an SQL query. How does the data come out now? In what way does it have to be formatted? /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic information transfer | Excel Discussion (Misc queries) | |||
Automatic Record Transfer | Excel Worksheet Functions | |||
automatic data transfer | Excel Discussion (Misc queries) | |||
How to find a data in Sheet1,automatic transfer to Sheet2(Excel) | Excel Discussion (Misc queries) | |||
Toolbar buttons -- AS400 iSeries Transfer | Excel Discussion (Misc queries) |