Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

vb - ftp

Posted on 2004-11-18
12
Medium Priority
?
259 Views
Last Modified: 2010-05-02
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?
0
Comment
Question by:Sara_j_11
  • 5
  • 4
9 Comments
 
LVL 6

Accepted Solution

by:
bkthompson2112 earned 2000 total points
ID: 12614872
I use the Chilket FTP ActiveX control.

It works great and it's free.

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

Expert Comment

by:bkthompson2112
ID: 12614876
>Chilket

Sorry, it's Chilkat.

(too early)
0
 

Author Comment

by:Sara_j_11
ID: 12614945
I am a beginer can u pl. explain in detail with code on how to use it?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Sara_j_11
ID: 12615025
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
 
LVL 6

Expert Comment

by:bkthompson2112
ID: 12615124
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
 
LVL 6

Expert Comment

by:bkthompson2112
ID: 12615126
>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
 

Author Comment

by:Sara_j_11
ID: 12615518
it is an excel report .xls
0
 

Author Comment

by:Sara_j_11
ID: 12615563
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
 
LVL 6

Expert Comment

by:bkthompson2112
ID: 12615794
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question