Sir, you are really great. Previously I was creating a bat file to upload a local file to an ftp. But I got you macro to do it so nicely without creating a bat file. I have one more problem can I upload/ creat a dir/folder in ftp to enable me to upload the file into that folder.