By Mel Erbsland on Wednesday, 31 January 2018
Posted in Kutools for Excel
Replies 10
Likes 0
Views 7.9K
Votes 0
Hi there,

I brought Kutools specifically to replace text with images so I wouldn't have to write a VBA every time I create a pricelist.

My problem is it will only replace the word the first time it appears, not every time.

Example: I have a list of colours many are multiples, when I do the match import pictures it will only replace the first colour, not all the multiples.

Is there a way so I don't have to run it 40 times? VBA replaces every colour text in my selection, kutools only the first time it appears.

Thanks in advance!
Hello,
Are you talking about the Match Import Picture?
We will take a look at this issue.
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Jay,

Yup, thats the exact thing I am having issues with
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,
Thanks. We will take a look at this feature and try to add options for importing same images more than one time.
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello

I have the exact same issue, only 1 occurrence is matched

It's too bad

Anynews about an update ?

Thanks

DeeBee
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,
Please make sure the filename of the pictures are the same as the text (cell value) in the Worksheet.
Thanks in advance.
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Jay,

Let me rewrite the issue :

Imagine we have in Excel

apple
apple
orange
melon
banana

the 2 first line are the same

And we used "Match Import" with all files named correctly
we'll get :

apple => matched with apple.png Image Displayed
apple => NOTHING !!! <<<< NOK
orange => matched with orange.png Image Displayed
melon => matched with melon.png Image Displayed
banana => matched with banana.png Image Displayed

We would love to have
apple => matched with apple.png Image Displayed
apple => matched with apple.png Image Displayed <<<<< OK
orange => matched with orange.png Image Displayed
melon => matched with melon.png Image Displayed
banana => matched with banana.png Image Displayed

The issue also appears in that case :
apple
orange
melon
banana
apple

Ill get :

apple => matched with apple.png Image Displayed
orange => matched with orange.png Image Displayed
melon => matched with melon.png Image Displayed
banana => matched with banana.png Image Displayed
apple => NOTHING !!! <<<< NOK

You got it ?

Thanks for your understanding

Kind regards

DeeBee
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,
We will check this issue, and try to fix it soon.
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,
Have you installed the beta version?
Is it fixed?
Thanks.
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

I tried v17.00 and the bug is still there

I gonna give a try to your beta version

Thx

DeeBee
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post