Hi
Now I understand what you are trying to achieve (I think

).
If you are trying to automate the import process then have you tried recording a macro whilst you do the manual process. You can then use the macro for future imports and make it automatic.
Is this what you want?
Tony