Change Getfolder to a filepath directory.

[BPSJACK]

Hi,

I am using a code which looks up picture names from a cell value and inserts them into the workbook.

The code uses a Getfolder command to prompt the user to select the folder the pictures are in.
My question is can I amend this to always take the pictures from a specific directory without prompting the user?

Here is the code in question:

Please Login or Register  to view this content.

Any help you guys can offer would be much appreciated!
Thanks,

[bulina2k]

yes, replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[BPSJACK]

Thanks that solved it!

Whilst I'm here I was wondering whether rather than looking up the whole row I could change it to one cell (eg B5).

Im guessing it would mean changing something in:

Please Login or Register  to view this content.

Can anyone help?
Thanks,

[bulina2k]

I'm sorry but I don't understand your last question. The code in your last code matches perfectly the code in your first post...

[BPSJACK]

It does.

But the code in the orginal post looks up pictures for all cells in column B. I was wondering whether it would be possible to change the code so it only looks up pictures from cell B5.

Apologies if this was unclear.

[bulina2k]

try this way

Please Login or Register  to view this content.

if this doesn't work either, pls upload your file or a dummy file.

[BPSJACK]

That's brilliant. Thank you so much!

[bulina2k]

Thank you. Please mark the thread as [SOLVED] . See Thread Tools menu.