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

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.

Maybe you could use the FTP that comes with windows:

http://groups.google.com/groups?selm...7273%40msn.com

Brad wrote:

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.

--

Dave Peterson

Guess you didn't read the entire post:

and not using batch scripts?

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

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote in message
...
Maybe you could use the FTP that comes with windows:

http://groups.google.com/groups?selm...7273%40msn.com

Brad wrote:

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.

--

Dave Peterson

Nope, I didn't read the whole thread.



Tom Ogilvy wrote:

Guess you didn't read the entire post:

and not using batch scripts?

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

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
Maybe you could use the FTP that comes with windows:

http://groups.google.com/groups?selm...7273%40msn.com

Brad wrote:

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.

--

Dave Peterson


--

Dave Peterson

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
Guess you didn't read the entire post
and not using batch scripts
But maybe the OP didn't mean dynamically created batch scripts
-
Regards
Tom Ogilv
"Dave Peterson" wrote in messag
..
Maybe you could use the FTP that comes with windows
http://groups.google.com/groups?selm...C7273%40msn.co
Brad wrote
I'm new to vba and I need to transfer files from my local drive to a
ftp server. Everything I've read tells me I need MS Internet Transfe
Control and it's really easy! However, when I try to reference it on my p
it states ""You Don't Have a License". I believe it's because I need
developer licence for Excel
Is there anyway I can a copy of the control without developer edition a
our company doesn't hold this edition
If I do get a copy, will it matter if the users who'll be running th
program don't have developer editions
Is there anyway to do this without this control and not using batc
scripts
Thanks in advance
-
Dave Peterso


--

Dave Peterso

Sometimes invisible to the user means that it doesn't use it!

Brad wrote:

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:
Guess you didn't read the entire post:
and not using batch scripts?
But maybe the OP didn't mean dynamically created batch scripts.
--
Regards,
Tom Ogilvy
"Dave Peterson" wrote in message
...
Maybe you could use the FTP that comes with windows:
http://groups.google.com/groups?selm...7273%40msn.com
Brad wrote:
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.
--
Dave Peterson


--

Dave Peterson



--

Dave Peterson