Steve,

I've no idea if this works for FTP or if it is site specific but this is
from Stephen Bullen, John Green, Bovey, Rosenberg's book.

set obk = ")

obk.saveas "

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Steve Brennan" wrote in message
...
If you manually save a file to an FTP site in Excel, you
get the FTP log on dialog where you are prompted for
username and password to log into the FTP site...

How do you log on to the FTP site using Visual Basic so
the SaveAs method doesn't fail, since there is no argument
for providing the username & password required to access
the FTP site?

Thanks,

Steve Brennan