Hi Grant,

This is what I am trying
to avoid. Maybe I need to use some other way to ftp the file instead of the
SaveAs? How else can I do this?

Just a suggesting, but you could try embedding the username and password in
the ftp location:

ActiveWorkbook.SaveAs "

Regards

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