I've got some VBA code that lets me send and receive files by having excel automate writing batch files to be run in a Windows command shell. I'm trying to find a way to let the user use this method to delete files from the remote server using excel. I can do this by having excel send a delete command through the shell, but first I need to provide the user with a list of files in the remote directory. I can get it to show up in the command window; is there an easy way to save the directory list to a file?
Thanks!
Bookmarks