Open directory for multiple times to import photos

Hello Jamelh,

There are a couple of ways you could solve this, open many folders to copy images.

If you know the folders, and they are all the same, I would maybe list all the folder paths in a sheet or in an array in the code.

Another way would be to recursevely loop all folders inside the downloads folder (or whichever folder you choose). This can only be used of course, if you want to import all photos in all subfolders.
https://www.excelhowto.com/macros/ho...use-excel-vba/

The final way I am thinking about is what you say, a dialog to select the folder. This would be the Filedialogfilepicker.
https://analystcave.com/vba-applicat...g-select-file/

Hope that helps!

A simple possiblility...

Please Login or Register  to view this content.

Hello,

Thank you for the info. I found reading this is really helpful for me as a beginner.

1- first suggestion, unfortunately this can't be done because the code has to be run every day for several times.
2- I want to select 2 or 3 folder only
3- msoFileDialogFolderPicker worked

Thanks a lot and I appreciate your effort.

Worked perfectly
Thanks a lot!

In my case I am selecting the first folder, resizing the photos and then placing each picture every 50 cells downward.

If I want to run the code for 2 or 3 folders, what would be the best way to place the pictures in selected cells ?

for example, after running the code and selecting folder 1:

1: picture 1 will be placed in a merged cell ex. A50
2- picture 2 .... A80
3- picture 3 .... A120

then running the code for another time with another folder will place the pictures in another cells, ex. A150, A180, A210

how to add this feature ? I hope it is clearly described

Thanks in advance

Originally Posted by MrChulo

Hello Jamelh,

There are a couple of ways you could solve this, open many folders to copy images.

If you know the folders, and they are all the same, I would maybe list all the folder paths in a sheet or in an array in the code.

Another way would be to recursevely loop all folders inside the downloads folder (or whichever folder you choose). This can only be used of course, if you want to import all photos in all subfolders.


The final way I am thinking about is what you say, a dialog to select the folder. This would be the Filedialogfilepicker.


Hope that helps!

Hello,

Thank you for the info. I found reading this is really helpful for me as a beginner.

1- first suggestion, unfortunately this can't be done because the code has to be run every day for several times.
2- I want to select 2 or 3 folder only
3- msoFileDialogFolderPicker worked

Thanks a lot and I appreciate your effort.

Originally Posted by dangelor

A simple possiblility...

Please Login or Register  to view this content.

Worked perfectly
Thanks a lot!

In my case I am selecting the first folder, resizing the photos and then placing each picture every 50 cells downward.

If I want to run the code for 2 or 3 folders, what would be the best way to place the pictures in selected cells ?

for example, after running the code and selecting folder 1:

1: picture 1 will be placed in a merged cell ex. A50
2- picture 2 .... A80
3- picture 3 .... A120

then running the code for another time with another folder will place the pictures in another cells, ex. A150, A180, A210

how to add this feature ? I hope it is clearly described

Thanks in advance

Originally Posted by rollis13

Oh, I'm late, anyway here is what I came up with:

Please Login or Register  to view this content.

If you don't need to choose the folder from which you need to import the files, because you already know these names, then you could use an array and hardcode the names of the paths and loop through them.

Thank you.

I am getting Compile error Ambiguous name detected: Insert

dangelor any updates please ?

Not sure what you're asking of me...

The unlike the file picker, the folder picker will only allow you to choose one folder. Could you create a simple for/next to call the procedure 3 times?

Originally Posted by dangelor

Not sure what you're asking of me...

The unlike the file picker, the folder picker will only allow you to choose one folder. Could you create a simple for/next to call the procedure 3 times?

yeah it is okay to run the code for another time and not have a selected range to place the photos in as long as I can sort them below each other with difference of 50 rows every time I run the code,

The first time the photos will be placed in rows 50, 100, 150, 200.

The next run I want the photos to be placed in 250, 300, 350, 400

how to do so please

Since the variable counter is never reset, start the loop just before the folder picker and end it just before the end of the sub.

Originally Posted by dangelor

Since the variable counter is never reset, start the loop just before the folder picker and end it just before the end of the sub.

could you please help me more, I am still new to VBA

Possibly...

Please Login or Register  to view this content.

Originally Posted by dangelor

possibly...

Please Login or Register  to view this content.

worked superrrr
thank you alot

Originally Posted by dangelor

Possibly...

Please Login or Register  to view this content.

I have one more question please.
If i=3, then I decided to add photos from 2 folders only .. I click cancel when the dialog opens for the third time ... here the photos from folder 2 are being re-added.
The function is continuing to work even when clicking cancel.
What would be a possible solution.