Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

FTP a file to UNIX server using Excel Macro

0 views
Skip to first unread message

narendra vuradi

unread,
Apr 17, 2007, 10:12:08 AM4/17/07
to nvu...@gmail.com
hi all,

i have a requirement where in i have to code a macro in excel which
will FTP a file to UNIX server.
i am new to working in excel macro's. Could anyone please tell me how
do i approach it and if possible possible solution

Thanks
Naru

David G

unread,
Apr 17, 2007, 11:12:50 AM4/17/07
to
Take a look at:
http://www.dailydoseofexcel.com/archives/2006/01/29/ftp-via-vba/

They present two solutions, one using VBA combined with the Windows
FTP program (SendViaFtp procedure on that site) and another using the
Windows API (no examples provided, but you can find more info at the
Microsoft MSDN site).
I haven't tried to implement it, but I see no reason why it shouldn't
work as they specified. Using Windows API is always more complicated,
so you probably want to avoid that.

Good luck,
David G

0 new messages