Thread: Passwordproblem when saving to ftp-server
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Bednarek[_8_] Michael Bednarek[_8_] is offline
external usenet poster
  
Posts: 21
Default Passwordproblem when saving to ftp-server
On Tue, 22 Feb 2005 14:14:08 +0100, Mette Yri wrote in
microsoft.public.excel.programming:

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[:password]@]server[/path]"
e.g. "

Never tried it in Excel, though.

Good luck.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"
Reply With QuoteReply With Quote