hi Joe,

I realise this is quite an old thread now, but, do you still need any help with this?

If so, I suggest recording a macro by pressing [alt + T + M + R] in excel of your excel-based actions and then posting that in this thread.

hth,
Rob