FTP batch file with excel files to run

April 8, 2010 at 17:04:50
Specs: Windows XP Pro
I'd like to run an automated program that makes all this:
Start@HH:MM:SS daily

erase all files in C:\myfolder\down

connect to ftp.MYSITE1 username password

download file ftp://ftp.MYSITE1/MYFOLDER1/myfile to C:\myfolder

overwrite on existing file

download all files in ftp://ftp.MYSITE1/MYFOLDER2 to C:\myfolder\down

300sec later

---This runs a batch file in order to rename all files---
run C:\myfolder\myfileA.bat

---This opens an excel file with a macro inside---
open C:\myfolder\myexcelfile.xls

---This enables content in the file [Excell office SP2 2007]---
Enable content

---This runs the macro in order to run the macro----

wait 60sec

close Excell without saving changes

connect to ftp.MYSITE2 username password

upload file C:\myfolder\myphpfile.php to ftp://ftp.MYSITE2/MYFOLDER3

upload all files from C:\myfolder\down to ftp://ftp.MYSITE2/MYFOLDER3


Thank you for your help

See More: FTP batch file with excel files to run

Report •

April 8, 2010 at 18:21:02
@echo off & setlocal
cd c:\myfolder\down
del /y *.*
cd ..
>ss echo open my.isp.net
>>ss echo username
>>ss echo passw
>>ss echo cd myfolder1
>> ss echo get myfile
>> ss echo cd ../myfolder2
>> ss mget *.*
>> ss quit
ftp -s:ss
ping -n 1 -w 300000
call c:\myfolder\myfilea.bat
:: do excel stuff - no knowledge here!
ping -n 1 -w 60000
> s2 echo open ftp.mysite2
>> s2 echo username
>> s2 echo pass
>> s2 echo cd myfolder3
>> s2 echo put myfolder/myphpfile.php
>> s2 echo mput down/*.*
>> s2 echo quit
ftp -s:s2
::---- end
prob'ly useless, since i don't know how to handle the excel stuff. Most likely will need vbscript for that part.
::-- edit oops, slashes going wrong way last couple lines. edited to fix

Report •

April 9, 2010 at 04:58:05
Thanks for this quick reply
I'll try to manage something with excel file
This allready very helpfull
Thx again, I'll let you know if it works probably after the week end.

Report •

Related Solutions

Ask Question