Send Files To FTP - Can't use Internet Transfer Control ActiveX

B

Brad

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
 
T

Tom Ogilvy

Message 3 in thread
From: Jake Marx ([email protected])
Subject: Re: 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 said:
I'm new to vba and I need to transfer files from my local drive to an ftp
Click to expand...
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
Click to expand...
our company doesn't hold this edition?
If I do get a copy, will it matter if the users who'll be running the
Click to expand...
program don't have developer editions?
 
T

Tom Ogilvy

Guess you didn't read the entire post:
and not using batch scripts?
Click to expand...

But maybe the OP didn't mean dynamically created batch scripts.

--
Regards,
Tom Ogilvy


Dave Peterson said:
Maybe you could use the FTP that comes with windows:

http://groups.google.com/[email protected]
Click to expand...
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.
 
D

Dave Peterson

Nope, I didn't read the whole thread.



Tom said:
Guess you didn't read the entire post:


But maybe the OP didn't mean dynamically created batch scripts.

--
Regards,
Tom Ogilvy


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.
Click to expand...
 
B

Brad

Thanks both, I'll give these a try. I didn't want to use batch scripts but dynamically created ones would do fine


----- Dave Peterson wrote: ----

Nope, I didn't read the whole thread



Tom Ogilvy wrote
 
Top