Windows 2000 FTP

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

Hi All,

I have an application which I used to get an CSV file daily.After I
get this csv file ,i do some work with the excel file and then email
it back.This was done manually.Recently the CSV file was shifted to a
FTP location and I used to manually retrieve the file and save it
back.
Is there a way to automate this via VBA?

Thanks,

Roy
 
From: "Roy" .

| Hi All,
|
| I have an application which I used to get an CSV file daily.After I
| get this csv file ,i do some work with the excel file and then email
| it back.This was done manually.Recently the CSV file was shifted to a
| FTP location and I used to manually retrieve the file and save it
| back.
| Is there a way to automate this via VBA?
|
| Thanks,
|
| Roy

You can use any scripting language in combination with the FTP command.
I use the KiXtart scripting laguange in conjunction with the MS FTP command.

You should ask in any choice scripting News Group.

--
Dave
http://www.claymania.com/removal-trojan-adware.html
Multi-AV - http://www.pctipp.ch/downloads/dl/35905.asp
 
Last edited by a moderator:
I use WinAutomation to handle FTP and Excel automation. and I'm very
happy with it.
You can download it from http://www.winautomation.com/


On Jan 17, 1:14 am, "David H. Lipman" <DLipman~nosp...@Verizon.Net>
wrote:
> From: "Roy" .
>
> | Hi All,
> |
> | I have an application which I used to get an CSV file daily.After I
> | get this csv file ,i do some work with the excel file and then email
> | it back.This was done manually.Recently the CSV file was shifted to a
> |FTPlocation and I used to manually retrieve the file and save it
> | back.
> | Is there a way toautomatethis via VBA?
> |
> | Thanks,
> |
> | Roy
>
> You can use any scripting language in combination with theFTPcommand.
> I use the KiXtart scripting laguange in conjunction with the MSFTPcommand.
>
> You should ask in any choice scripting News Group.
>
> --
> Davehttp://www.claymania.com/removal-trojan-adware.html
> Multi-AV -http://www.pctipp.ch/downloads/dl/35905.asp
 
Last edited by a moderator:
Back
Top