Recent content by MitchJP

Thanks A! This is working perfectly now... You've been a lot of help! Thank you very much! Mitch

Neither code sample works.... yet - :) The original code deletes all instances of the target text, but then continues to loop until I break. No image is placed anywhere. The second sample of code replaces the first instance of the target text and loops, placing the same image over and over in...

When I debug, the cursor is on a different line every time. So it's replacing the first instance of the Text, then plugging the image into the same cell over and over.

Actually, it's now running but once it replaces one instance of the text it's searching for, it appears to loop indefinitely. Occasoinally I get an Object variable or With block not defined error as well, but only when there are no more instances of the target text found (or so it appears).

Thanks Loomah, when I run this macro it doesn't appear to do anything. It runs and nothing is replaced.

Thanks for the help A! One question, this appears to keep looping, and doesn't stop until I kill the macro. Any ideas?

Hi all, I'm trying to write a macro in Excel that will all instances of a word and replace it with an image. Any ideas? Is this possible? Ideally I'd like the image to be anchored to the cell that the word was in. Thanks, Mitch

I can't find this file anywhere. Can someone tell me where to find it?

Can you tell me what the specific file name is for this Adobe Sams MM file? Or is that literally it? Thanks, Mitch

Hey fstrahberger, that worked (or at least I'm getting results now). Thanks! I'll validate it and let you know.. Thanks again, MitchJP

they are local tables.

That didn't work. I tried something similar and had no luck.

No, I'm not seeing if they are equal. For example, I'm searching for "Australia" within "Once upon a time, I went to Australia". So normally I'd use LIKE "*Australia*". But in this case I don't want to compare it to a string like "Australia" but to a whole list of country names. Does this...

I'm trying to write a query using LIKE. I know how to do this when I'm comparing a field to a string, but how do I do this when comparing a field to another field? So where we do this: WHERE table1.field1 LIKE "*joe*" How do I do this: WHERE table1.field1 LIKE table2.field2 Any ideas...

Nevermind, I've figured it out. Somehow the data source for the form was erased... So I've resolved it. Thanks for the help!