Passwordproblem when saving to ftp-server

  • Thread starter Thread starter Mette Yri
  • Start date Start date
M

Mette Yri

Hi!

Does anybody know how to put the password into the code when saving to
a ftp-server in VBA? I use this code, but have to connect to the
ftp-server with the password manually every time I open excel.

ActiveWorkbook.SaveAs Filename:=
"ftp://ftpserver.com/dir/dir/myfile.xls"

Thanks in advance,
Mette
 
Hi!

Does anybody know how to put the password into the code when saving to
a ftp-server in VBA? I use this code, but have to connect to the
ftp-server with the password manually every time I open excel.

ActiveWorkbook.SaveAs Filename:=
"ftp://ftpserver.com/dir/dir/myfile.xls"
Click to expand...

The usual syntax is: "ftp://[user[:password]@]server[/path]"
e.g. "ftp://[email protected]:p[email protected]/dir/dir/myfile.xls"

Never tried it in Excel, though.

Good luck.
 
Michael said:
Hi!

Does anybody know how to put the password into the code when saving to
a ftp-server in VBA? I use this code, but have to connect to the
ftp-server with the password manually every time I open excel.

ActiveWorkbook.SaveAs Filename:=
"ftp://ftpserver.com/dir/dir/myfile.xls"
Click to expand...

The usual syntax is: "ftp://[user[:password]@]server[/path]"
e.g. "ftp://[email protected]:p[email protected]/dir/dir/myfile.xls"

Never tried it in Excel, though.

Good luck.
Click to expand...

Thanks, but this doesn't work - I still have to connect manually
before the code does its job.

Anybody?
 
My understanding is that there is no standard for this. Some sites support
what Michael suggested. Apparently yours doesn't. Perhaps you could
contact the webmaster and see what they say.

--
Regards,
Tom Ogilvy

Mette Yri said:
Michael said:
Hi!

Does anybody know how to put the password into the code when saving to
a ftp-server in VBA? I use this code, but have to connect to the
ftp-server with the password manually every time I open excel.

ActiveWorkbook.SaveAs Filename:=
"ftp://ftpserver.com/dir/dir/myfile.xls"
Click to expand...

The usual syntax is: "ftp://[user[:password]@]server[/path]"
e.g. "ftp://[email protected]:p[email protected]/dir/dir/myfile.xls"

Never tried it in Excel, though.

Good luck.
Click to expand...

Thanks, but this doesn't work - I still have to connect manually
before the code does its job.

Anybody?
Click to expand...
 
Tom said:
My understanding is that there is no standard for this. Some sites support
what Michael suggested. Apparently yours doesn't. Perhaps you could
contact the webmaster and see what they say.
Click to expand...

Okay, I'll try that.
Thanks =)
 
Back
Top