Subj : Re: Open a file from an FTP server within a VB Macro To : comp.programming From : Ed Prochak Date : Fri Sep 23 2005 01:05 pm Claudia wrote: > 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 try one of the Microsoft groups, maybe one specifically for VB HTH. ed .