| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
open ftp file with password
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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
open ftp file with password
Sorry, meant to post this under programming..
"Kevin" wrote: 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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PAssword protected file will not open | Excel Discussion (Misc queries) | |||
| Forgotten password to open .xls file | Excel Discussion (Misc queries) | |||
| Password to open file | Excel Discussion (Misc queries) | |||
| I can't turn off the password to open a file in excel. | Excel Discussion (Misc queries) | |||
| how do i give password to open for Excel File? | Excel Discussion (Misc queries) | |||
Linear Mode
