Execute FTP Commands with VBA

[mchac]

I have FileZilla installed and would like to pass commands to it from VBA.
This site: How to Execute FTP Commands With VBA | eHow.com
has some instructions on how to accomplish this but the last instruction says to add the following to VBA code which executes a batch file which then executes an FTP Command File:

Shell ("doFtp.bat"), vbHide '', vbMinimizedNoFocus

It goes on to say that the line contains two single quotes, without any character between them, immediately before the second comma. However this will only create a comment after the first single quote so the rest of the line is ignored.

Does anyone have an alternative command or methodology to execute FTP via VBA?

 

[mchac]

sweet indeed. absolutly awesome.
My path was wrong. I didn't realize you could skip the Archives part of the path.

This is not only easier but I think it's faster than the batch file to txt file to ftp software route.

Thank you very much!

 

[rjwebgraphix]

sweet indeed. absolutly awesome.
My path was wrong. I didn't realize you could skip the Archives part of the path.

I got the path by logging into the server as well as using the path you gave. I didn't see an Archives directory, but did see the Edgar directory, so just worked back from there.

Sometimes it is just a matter of getting the question in front of the right brain.

Maybe John could answer this one.

Lets say it isn't an anonymous ftp server. How would one pass the login and password.

I tried this....

DownloadFile "ftp://myusername@ftp.nelacat.com/rjfiles.nelacat.com/bmx/peixebike!.jpg", "C:\rj\excel\peixebike!.jpg"

but without the password it does nothing. it's just a picture of my bike. I just wanted to see if it would work, which gave me an idea of automating some of the website logs I monitor. (Personal related, not business related)

 

[rjwebgraphix]

Answered my own question just as soon as I hit send. It's the same as passing the username and password in url in the browser, so would be like this....

DownloadFile "ftp://myusername:mypassword@ftp.nelacat.com/rjfiles.nelacat.com/bmx/peixebike!.jpg", "C:\rj\excel\peixebike!.jpg"

Edit: As a side note. the web address is like this. www.rjfiles.nelacat.com/bmx/peixebike!.jpg which further illustrates how ftp directory structures and web url structures can be different.

 

[testnopassive]

passive-ftp (passive-ftp.com) IS A MESS

it doesn't work, and you will never get your money back

 

[mchac]

well, it does work for me. however direct download the way John suggested and rj commented on above has fewer moving parts.

 

[cutthegrass]

I know this is an old thread, but I've been looking for something like this for days. Tried many other approaches. None worked despite hours of effort. This worked within 5 minutes! Thank you RJ and mchac.

Is there something similar to upload a file to a site?

Many thanks for any assistance you can provide.

 

[mchac]

i don't know though a quick search doesn't show any similar command to URLDownloadToFile. suggest you start a new post asking about this.

 

[cutthegrass]

Will do. I've checked too and haven't found anything similar.