Message 3 in thread
From: Jake Marx )
Subject: Is it possible to FTP from Excel using VBA?


Newsgroups: microsoft.public.excel.programming
Date: 2000/02/16


Hi Ryan (and Harald),

It looks like the example at Ole's site uses SendKeys to do the transfer,
which IMO isn't a very reliable way to do it.

One alternative would be to use an ActiveX control to add FTP functionality.
I tried a free one a while back called EZFTP that worked well and was very
easy to use. You can find it at http://www.coolstf.com/activex.html. Let
me know if you need an example of how to use it, and I'll email the code to
you directly.

HTH,
Jake Marx


--
Regards,
Tom Ogilvy


"Brad" wrote in message
...
I'm new to vba and I need to transfer files from my local drive to an ftp
server. Everything I've read tells me I need MS Internet Transfer Control
and it's really easy! However, when I try to reference it on my pc it states
""You Don't Have a License". I believe it's because I need a developer
licence for Excel.

Is there anyway I can a copy of the control without developer edition as
our company doesn't hold this edition?
If I do get a copy, will it matter if the users who'll be running the
program don't have developer editions?
Is there anyway to do this without this control and not using batch
scripts?

Thanks in advance.