title: Excel VBA list files from a URL
body: <p>Ok, how would I hist all the files in a folder that is located on a remote server that I have to access using a URL e.g. <a href="http://domain.com/folder" rel="nofollow">http://domain.com/folder</a> and inside the folder there are a bunch of files that I would like listing into excel. There are functions do this when trying to list files in a folder that are on your current C:\ but they don't work when trying to list files from a URL. I am not sure if this can be done! Thanks </p>