Hi Grant,

I've tried that and it doesn't work. I get the same run time error.

Darn! Then I guess the only choice is to save the file locally, then
transfer it using the FTP control.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk