Save to FTP site through a macro
 

I have a macro that worked fine in Excel97, but do not
have the same results in 2000. When the user would SAVE AS
to an FTP site, if the user had not signed on previously,
they were prompted to sign on. I now have to create a
method to sign on ahead of time, or else modify the macro
to allow prompting. Any suggestions?