Passwordproblem when saving to ftp-server

[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

 

[Michael Bednarek]

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"

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

Never tried it in Excel, though.

Good luck.

 

[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"

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

Never tried it in Excel, though.

Good luck.

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

Anybody?

 

[Tom Ogilvy]

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

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"

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

Never tried it in Excel, though.

Good luck.

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

Anybody?

 

[Mette Yri]

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.

Okay, I'll try that.
Thanks =)