Sara_j_11
asked on
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?
Also can I do that directly from my VB program that is currently reading my sql and writing it out to an excel file?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am a beginer can u pl. explain in detail with code on how to use it?
ASKER
Also pl. tell me how to manually drop a report in excel format into the ftp site after I login to the ftp site?
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(txtDumpPa th.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.
With ChilkatFTP
.ErrorLogClear
.Username = txtUserName.Text
.Password = txtPassword.Text
.HostName = txtHostName.Text
If .Connect Then
If .ChangeRemoteDir(txtDumpPa
.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.
>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?
What kind of report?
ASKER
it is an excel report .xls
ASKER
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...
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.
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.
Sorry, it's Chilkat.
(too early)