Rob... it worked!! I used:
Application.SendKeys "+{tab}xxxx~"

I had to use the shift+tab to get focus on the password field. Now, the user
doesn't even see the log in, which is what I wanted. Fantastic!

At first I made a common mistake, however. I had the SendKeys after the Open
action that launched the FTP log in dialog box. Once I moved it to before
the Open action, it worked beautifully. I love it!

I greatly thank you again for all your wonderful assistance. You don't know
how long I have been researching this little obstacle and with many people.
I became obsessed over it, but I'm grateful I didn't give up and found you
here.

Do you offer like a summer boot camp for VBA? Let me know and I'll send a
check and book a flight! <g

Pat

"Pat Beck" wrote in message
...
Thanks, Rob. I'll look into SendKeys, although I've never used it before.
I
hope it's not too difficult. <g

The reasons I suspect the FTP log in to be part of office is that 1) it
looks very different than the standard FTP log in from ftp.exe. Also, 2)
the
FTP log in I speak of has its registry settings inside Microsoft Office
keys. It's found at:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\C ommon\DrawAlerts\FTP
Sites\site_0. Of course the last key (site_0) appears only if you have
added
a site through an Office program. 3) Unlike normal FTP connection setup,
this FTP log in set up can only be done through an Office program.
(File|Open|LookIn|FTP Locations)

Maybe I've mislead myself, but it seems like this is part of Office. Many
experts I spoke with were not aware of this FTP set up. Do you have
thoughts
about it?

In the meantime, I'll try the learn the SendKey method. I hope you won't
mind me asking for help again should I run into problems with it, which I
likely will. <g

Many thanks as always.

Pat

"Rob Bovey" wrote in message
...
Hi Pat,

I don't think an FTP log-in dialog would be part of Office. That
kind
of
authentication is controlled by the FTP server. I don't have the right
test
configuration available to work out the specifics, but I suspect that
you
could probably populate the dialog from your code by sending it
keystrokes
using the SendKeys method.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Pat Beck" wrote in message
...
I wonder if I can push my luck and get one more question answered
about
my
project? <g

I have simple code that saves to an FTP site and it works fine.

ActiveWorkbook.SaveAs Filename:= _
" ftp://www.name.com/public/Budget.xls ", _
FileFormat:=xlNormal, Password:="", _
WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False

But Office has an FTP Log In dialog box that asks for a password. Is
there
ANY way possible to program that puppy to take a password via code?
Even
if
it only enters it as the default password - leaving the user to merely
click
OK without actually entering it.

I've even tried hacking the registry, but it doesn't seem to hold a
password
either - and I've spoken to a registry expert who shrugged his
shoulders
too.

I take it this FTP Log In dialog box is part of Office, not so much
Windows.
Can it, therefore, be controlled through VBA from Excel to take a
password?

Thanks.

Pat