Subj : Open a file from an FTP server within a VB Macro
To   : comp.programming
From : Claudia
Date : Thu Sep 22 2005 06:47 am

Hallo,

I'm trying to write a litte macro that opens me a specitic file from a
FTP server where I have to lock in with my username and password.

Unfortunately I don't manage. I tried to use a simple
Workbooks.Open Filename: ftp://USERNAME:PASSWORD@XXXXXX.com
bur the macro doesn't come back and I have to shut down Excel.

Can any one help me PLEASE???

Thanks,
Claudia

.