vb - ftp

I am given an user name and password to an ftp site and they want me to drop a report every month into that report. How do I do that ? Do I have to use html?
Also can I do that directly from my VB program that is currently reading my sql and writing it out to an excel file?
Sara_j_11Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bkthompson2112Commented:
I use the Chilket FTP ActiveX control.

It works great and it's free.

Get it here: http://www.chilkatsoft.com/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bkthompson2112Commented:
>Chilket

Sorry, it's Chilkat.

(too early)
0
Sara_j_11Author Commented:
I am a beginer can u pl. explain in detail with code on how to use it?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Sara_j_11Author Commented:
Also pl. tell me how to manually drop a report in excel format into the ftp site after I login to the ftp site?
0
bkthompson2112Commented:
Using the Chilkat component would look something like this:

With ChilkatFTP
  .ErrorLogClear
  .Username = txtUserName.Text
  .Password = txtPassword.Text
  .HostName = txtHostName.Text
       
  If .Connect Then
    If .ChangeRemoteDir(txtDumpPath.Text) Then
      .PutFile(txtFileName.Text)
    End If
  End If
  .Disconnect
End With

Of course, you would want to add error handling to this, but
the Chilkat component is quite easy to use.
0
bkthompson2112Commented:
>Also pl. tell me how to manually drop a report in excel format into the ftp site after I login to the ftp site?

What kind of report?
0
Sara_j_11Author Commented:
it is an excel report .xls
0
Sara_j_11Author Commented:
By the way how long would it be available for free. I work for a company; and  this is a an important report that has to be saved to the ftp site every month and it is time bound. I dont want the report to not be saved to location because of something suddenly happening to the web site. In that case what can I do. Is there a software that I can buy ofrthat is not too expensive, so that I dont have to worry about the time based report... should they decide to close this web site...
0
bkthompson2112Commented:
I've been using Chilkat for over a year now.

The FTP component is a free download.  It doesn't depend on the website.

Just download the component, add it to your project, write some code,
and you can use it forever.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.