Guest Roy Posted January 16, 2008 Posted January 16, 2008 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
Guest David H. Lipman Posted January 16, 2008 Posted January 16, 2008 Re: FTP From: "Roy" <praish1998@yahoo.com> | 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
Guest johnttlb@gmail.com Posted February 4, 2008 Posted February 4, 2008 Re: FTP 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" <praish1...@yahoo.com> > > | 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
Recommended Posts