open ftp file with password

G

Guest

I am using this statement to open an ftp file.

Workbooks.Open Filename:= _

"ftp://10.12.41.22/opt/app/srts/prod/apache/htdocs/storage/csv/storage_data09-04-2007.csv"

When it runs it asks for the user id and password if the machine has been
rebooted since the last time it was opened.
Is there a way to pass the user id and password in the open statement?
This is part of an automated process and I would like to avoid having to
type in a password every time the machine gets rebooted...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

open ftp with password 2
VBA code to download csv file from FTP site 6
FTP transmits user id and password in plain text? Best case/ worsecase analysis requested 14
Sending mail from outlook using VBA masro 1
FTP question 4
FTP question... 7
Open word document with Vista FTP 2
Need help with ftp script 3

Top