FileDialogue selection code adjustment needed

[Kelly mort]

This was the original post at mrexcel.com.

FYI: when I tried posting the link here, I am not allowed to do so.


The challenge gets tougher and I have to call on Tech support.
When I click on a command button, I want to access the open dialogue box where I select an image file from a folder - this could be anywhere on the computer.

Then I rename that image with the content in textbox1 (for example).

Then I later copy that image to a folder, "MyLocation", located at the same location of the workbook.

So here, it could happen that the selected image is located in the " MyLocation" folder.

And in this case, we just rename it but we don't copy.

Please Login or Register  to view this content.

Then after a few days of no reply, I was able to post this back to the forum:

I have managed somehow half-way to be able to come to what I wanted to achieve. I did this by doing some addition and subtraction of some pieces of codes. If there is anything that needs to be cleaned and make the algorithm prettier, then, I am looking up to that. If there are issues with my variable usage, I will like to be informed as well.

Where I have placed those comments I want them fix for me.

Those parts became more than I could process ATM.

Thanks for having a look at this for me.

Please Login or Register  to view this content.

Can somebody please point me to where I went wrong with the above and make it better for me?

Also how to fix those comment parts of the code?

Thanks

[Pepe Le Mokko]

As you now have 5 posts you can post a link to your cross post. I cannot find your post at MrExcel

[Kelly mort]

As you now have 5 posts you can post a link to your cross post. I cannot find your post at MrExcel

This is the thread title:

VBA select image from open dialogue box and rename selected image with content of a textbox

[Pepe Le Mokko]

Why don't you add the link? As I said, after 5 posts you are allowed to do so?

[Kelly mort]

I have tried several times posting the link but get same error alert

[Pepe Le Mokko]

Here you go https://www.mrexcel.com/forum/excel-...ontent+textbox