open ftp with password
 

This is a repost from worksheet functions, I put it in the wrong section. :)

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...

open ftp with password
 

you can pass the username and password in the FTP url using this syntax:

ftp://user:password@host/path


--
Hope that helps.

Vergel Adriano


"Kevin" wrote:

This is a repost from worksheet functions, I put it in the wrong section. :)

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...

open ftp with password
 

PERFECT!!!!! Thanks so much!!

"Vergel Adriano" wrote:

you can pass the username and password in the FTP url using this syntax:

ftp://user:password@host/path


--
Hope that helps.

Vergel Adriano


"Kevin" wrote:

This is a repost from worksheet functions, I put it in the wrong section. :)

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...