PPRuNe Forums - View Single Post - Excel VBA Query
Thread: Excel VBA Query
View Single Post
Old 16th July 2011 | 14:37
  #5 (permalink)  
BOAC
Per Ardua ad Astraeus
 
Joined: Mar 2000
Posts: 18,575
Likes: 4
From: UK
I need to beg some more VBA help - my thanks indeed to those who helped before.

I am 'firing on all four' now but am stuck on FTP issues. I am able to FTP files up and down, creating the necessary TEXTFILE to "get" or "put" inthe code and using "FTPcommand = "ftp -n -s -v:" & Chr(34) & TEXTFILE & Chr(34)" to execute the up/down request.

What I would like to do is use the same procedure to list the files on my server and add them to a listbox.but I cannot work out how to use "dir" to achieve this. If anyone can help I can PM the current lines of code. Google seem to be devoid of simple subs or functions.
BOAC is offline  
Reply