VBA insert image based on cell value with exceptions

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

Hi,

I have a VBA code, which pulls images from my picture drive based on cell value entered in excel sheet. My problem is that I have high quality images and low quality images, the name of which is the same as the high quality one + '-th'.

e.g. the image named 'MERCURY-B' is high quality and 'MERCURY-B-th' is the same image with low quality.

When I type 'MERCURY' (the code pulls image even if the name is not full) or 'MERCURY-B' it always pulls the low-quality image, but I want the code to exclude all the low-quality images with '-th' and insert the one without it.

Also the code should skip images containing '-B-'.

Thank you

Excel Excel VBA Visual Basic

Project ID: #15209754

About the project

13 proposals Remote project Active 6 years ago

Awarded to:

The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc Relevant More

$20 USD in 1 day
(54 Reviews)
5.3

13 freelancers are bidding on average $36 for this job

schoudhary1553

Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. Relevant Skills and Experience I have more than 5 years of experience in e More

$150 USD in 2 days
(217 Reviews)
7.2
P0L

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD in 1 day
(219 Reviews)
6.8
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quali More

$35 USD in 0 days
(149 Reviews)
6.4
zu02

Hi, I'll fix your macro inserting images. Relevant Skills and Experience Excel, vba Proposed Milestones $55 USD - default

$55 USD in 1 day
(28 Reviews)
5.7
imteyazkhan85

Hi there, I am Imteyaz from India, As per your requirement, i will fix that program, and then your code will pull images as per your requirement. And also the code will skip images containing '-B- Relevant Skills an More

$30 USD in 1 day
(14 Reviews)
3.5
adamdavis1983

My bid for this project reflects delivering the requirements as outlined in the project description. Relevant Skills and Experience I am a lot of experience with VBA and am totally confident that I'll be able to deliv More

$15 USD in 1 day
(0 Reviews)
0.0
dheeraj907

Interested in you project. Relevant Skills and Experience Excel and vba Proposed Milestones $10 USD - Initial milestone $20 USD - final stone will ask if any.

$30 USD in 1 day
(0 Reviews)
0.0
rajdeeps101

A proposal has not yet been provided

$30 USD in 2 days
(0 Reviews)
0.0
rodneycoder

The code editing to do your fix will be minimal. I am bidding low on this because I need to get some rep as a trustworthy dev. If you choose me I will explain the exact changes for you. Thanks Rodney Relevant Skills More

$10 USD in 1 day
(0 Reviews)
0.0