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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 05/22/04


Date: Sat, 22 May 2004 13:12:00 -0400

Message 3 in thread
From: Jake Marx (Jake.Marx@americawest.com)
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" <anonymous@discussions.microsoft.com> wrote in message
news:774A1FCB-8205-4A11-8DDA-DE6EFB9AE8C0@microsoft.com...
> 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.
>
>
>
>


Relevant Pages

  • Re: Ping John Larkin
    ... Do you guys use VBA for instrument control? ... Most of the time it seems to be done in Excel. ... Windows programs but you can alter them, including pics, logos etc. ...
    (sci.electronics.design)
  • Excel controls vs vba controls
    ... Sorry posted this in Excel General before by mistake! ... I am new to VBA so just finding my feet, can anyone help me with the ... differences between an excel control ... lets say a checkBox and a vba checkBox? ...
    (microsoft.public.excel.programming)
  • Re: Adding nodes to treeview
    ... Ensure that you have a reference (VBA Tools menu, ... Microsoft MVP - Excel ... > Yeah I've already added the control to the tool box and to my> userform. ... >> "John" wrote: ...
    (microsoft.public.excel.programming)
  • Re: Dynamic Workseheets
    ... You'll have to use VBA. ... > When a user opens this file in Excel, ... > into Work Sheet4. ... > text file that may allow this action since I can control ...
    (microsoft.public.excel.worksheet.functions)
  • Re: RTF-Control nicht korrekt lizensiert
    ... > ich wollte eine neue Userform in Excel 2000 VBA erstellen. ... > MS Date and Time Picker Control 6.0 ... Prev by Date: ...
    (microsoft.public.de.excel)