VBA search a web folder for filenames?

[knifey]

Hi,
I'm trying to get a web folders contents so I can download any images that match a partial filename in my workbook (I'm not sure it's even possible in VBA).
This is my code so far but it falls over at strPath with "path not found":

Sub getWebFolderContents(strPath)
Dim objFSO, objFldr
Dim objFl
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFldr = objFSO.GetFolder(strPath)
For Each objFl In objFldr.Files
Debug.Print objFl.Name
Next
Set objFSO = Nothing
Set objFldr = Nothing
End Sub

Any advice or pointers would be much appreciated.
Thanks,
K

 

[PHV]

it falls over at strPath with "path not found"
And what is the value of strPath ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[knifey]

Hi PHV,
strPath is "

http://www.capelrugs.com/SupplyImages/Main_Images/"

But I've also tried "

http://www.capelrugs.com/SupplyImages/Main_Images"

This folder does exist. What am I doing wrong?
Thanks,
K

 

[PHV]

What am I doing wrong?
The FSO can't deal with URL but UNC.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[knifey]

Hi PHV,
Oh dear, is there a way to convert a url to a unc in vba? Or would I need to contact the website owner to find out the full unc path of where the files are kept?
Thank,
K