You can check this link at Randy Birch's site that shows how to connect with
a username and password:

http://vbnet.mvps.org/index.html?cod...tpdownload.htm

--
Regards,
Tom Ogilvy


"alfredo" wrote in message
...
Tom,

I've just picked up on this thread because I have a pretty similar need.

I have looked at your three links in some detail, but to be honest, not
sure
where to go next. In the links I am having some dificulty seperating
between
what is necesary, and what are (rather old?) downloads/add-ins(?).

I am trying to have excel open another excel file which is in an ftp
server.

I have no problem opening the file if I have previously conected to the
server, but if I have not done this already it prompts me for a user name
and
password (no problem in principle, but would rather be able to skip this
and
have it all in the code).

Looking through your references, I am pretty sure is should be fairly
simple, along the lines of the following:

FtpClient.URL = "ftp://address"
FtpClient.UserName = "username"
FtpClient.Password = "password"
FtpClient.Connect


but I am not sure what else I need to put around it (or if I really need
to
download and install the stuff in your three links).

Help would be very, very much appreciated.



"Tom Ogilvy" wrote:

http://www.vb-helper.com/howto_ftp.html

http://www.zarr.net/vb/download/codedetail.asp?code=258

http://www.vbip.com/protocols/ftp/vb...ry/default.asp

--
Regards,
Tom Ogilvy


"loopoo" wrote in
message ...

Hi!

Please let me know how is it possible to upload file(s) from your
computer to a server using Excel: is it possible to run Windows shell
commands in a macro ?? I was thinking to use ftp and to send the file
to that server (it's a UNIX server, for which I have an username and a
password)

Thanks,
Chris


--
loopoo

------------------------------------------------------------------------
loopoo's Profile:
http://www.excelforum.com/member.php...o&userid=28792
View this thread:
http://www.excelforum.com/showthread...hreadid=486825