Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Delete file from Server
Hi all,
I'm using WPut and WGet to upload and download files to a FTP Server but need some Access VBA code to delete a file from there please.
Maybe some FTP Shell command?
Thanks
Pierre
I'm using WPut and WGet to upload and download files to a FTP Server but need some Access VBA code to delete a file from there please.
Maybe some FTP Shell command?
Thanks
Pierre
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
@Kanti - thanks for the reply.
Could you provide more info as to how I would implement this in Access VBA please?
As explained the file I need to delete resides on my Web Server.
So I need some FTP command to delete the specific file
Could you provide more info as to how I would implement this in Access VBA please?
As explained the file I need to delete resides on my Web Server.
So I need some FTP command to delete the specific file
Hi
The one I gave you is to run it as a FTP command. Try it and if it works just put it as a .bat file and run it.
The one I gave you is to run it as a FTP command. Try it and if it works just put it as a .bat file and run it.
@Kanti - I created a bat file with ref to the http path to the file but I'm getting an error stating that the 'delete' or 'mdelete' command doesn't exist
Hi
Initially run just with the delete on that server then we can look giving the path name.
FTP> prompt
FTP> delete filename*.ext |yes
Initially run just with the delete on that server then we can look giving the path name.
FTP> prompt
FTP> delete filename*.ext |yes
@Kanti - OK I understand but I need the full code to login and do the delete from within VBA code.
I have an idea how to do it via Command Prompt but not sure how to do it all the way with VBA code.
Sorry - hope that make sense?
I have an idea how to do it via Command Prompt but not sure how to do it all the way with VBA code.
Sorry - hope that make sense?
There is no WDel for Windows, but you can run a script for the FTP utility:
WDel.cmd
WDel.cmd
@echo off
>file.txt echo open ftp.mysite.com
>>file.txt echo username
>>file.txt echo password
>>file.txt echo cd /directory
>>file.txt echo binary
>>file.txt echo del %1
>>file.txt echo disconnect
>>file.txt echo bye
ftp -i -s:"file.txt"
del "file.txt"
Premium Content
You need an Expert Office subscription to comment.Start Free Trial