Hi all! I'm having some trouble trying to recover a number of images from an online server.
I can manage to insert an image knowing it's absolute path + filename, but I just know the path.. The name of the *.jpg that's inside each folder is arbitrary, I just know that inside each directory there's just one jpg.
Each image path is obtained like this:
+"http://server.com/camaras/camara" & A4 & "/" & C1 & "/001/jpg/" & C2
Where in Column A is the camera number, in C1,D1,E1,, the day and in C2,D2,D3 the hour/minutes.
Here's an attachment of one of the folders I need to recover the .jpg from
I was trying to learn how to query each folder's content, get the name of the .jpg that's inside and insert it in the corresponding column/row.
As each folder's path is built with a text string plus the camera number in column A plus the contents of C1 and C2, D1 and D2, etc.. I was thinking of assembling the path inside the macro itself in a loop, adding the filename + extension to it and just insert the images where the folders links are, in the first attached picture.
Any kind of guidance is really appreciated!!
I can manage to insert an image knowing it's absolute path + filename, but I just know the path.. The name of the *.jpg that's inside each folder is arbitrary, I just know that inside each directory there's just one jpg.
Each image path is obtained like this:
+"http://server.com/camaras/camara" & A4 & "/" & C1 & "/001/jpg/" & C2
Where in Column A is the camera number, in C1,D1,E1,, the day and in C2,D2,D3 the hour/minutes.
Here's an attachment of one of the folders I need to recover the .jpg from
I was trying to learn how to query each folder's content, get the name of the .jpg that's inside and insert it in the corresponding column/row.
As each folder's path is built with a text string plus the camera number in column A plus the contents of C1 and C2, D1 and D2, etc.. I was thinking of assembling the path inside the macro itself in a loop, adding the filename + extension to it and just insert the images where the folders links are, in the first attached picture.
Any kind of guidance is really appreciated!!
