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