Open a file from ftp site

[ThaNguyen]

I have a macro that would open file on a ftp site but it would prompt a name a password everytime. Is there a way I could add the name and password with the macro that I would not have to enter name/password everytime

Thank you in advance

[Bob Phillips]

Using Sendkeys?

[ThaNguyen]

Using Sendkeys?

Not sure what you meant

[Bob Phillips]

Lookup sendkeys in VBA help, it allows you to send keystrokes to the activewindow.