open ftp file specifying user id and password
 

Is there a way to open a workbook on an FTP server using
VBA so that the client doesn't know the userid or
password? We were using an anonymous logon but must
change for obvious security reasons. We tried the vba
openfile command but there isn't an option to specify the
FTP user id or password, just the workbook password. We
want it to open as a workbook and am trying not to write
something to copy to a temp file and then opening that.
We also don't want the client to know the userid or
password. We are using Excel 2000. Thanks