Find and replace

Thank for replying to my post to see if this is possible.

I attached a two row sample of my data. My full workbook is very large with over 10,000 items with a lot more columns then what is showing. I just deleted a lot of the columns that are not really associated with what my request is about.

If you look at the column (C) Template, you will see the sample template html that I provided. In the html, you will see text with [[ ]] around text. That is the text that I would like to replace with data from the associated column. ( [[PRODUCT_NAME]] with PRODUCT_NAME data ) I want to do this for each [[ ]] in the template html.

Does this make sense?

Thank you SHG for that information. Please remember what I stated at the start of the topic. I am an novice here. I know that for many if not all other members here, they totally understood what that code means and does, but, I just said, WOW!

How would I go about in performing the code you just suggested.

Mail Merge? Never used it.

Thank you MartinD,

I just tested out the Mail Merge which it did do what I wanted for giving me the HTML with all fields filled in. BUT, how do I associate each new html with that row on my excel file?

Basically I want to have the template column or even a new column with the new html in it because then I have to use some of the columns not shown with the new html in an upload.

That mail merge did do the trick of what I wanted but then I would have over 10,000 of this html in word that I would have to manually put back into my excel file.

So, since that will not work, are there any other possible ways?

WOO HOO!

I finally figured out to use the code that SHG gave me above to make it work.

With the code that he supplied, do I need to set up a newly edit module for every find and replace I do? Or is there a code that would do all of them?

Hey SHG,

That code really worked great for the sample you gave me. I then tried editing the code to do another column but it came up with an error. I was doing the [[Description]] text with the column (D) Description. The column has some html style text in it. I am not sure if that matters.

This is the code I edited for that one:

Please Login or Register  to view this content.

Hello SHG,

I posted the workbook above in my second post.

SHG,

Yes, the code works for all the different column changes but not for the one for [[Description]] to be replace with column D (description)

This is the code I used.

Please Login or Register  to view this content.

When I run it, I get run time error 13

SHG,

You are a god! That worked perfectly! BUT, there is one issue though. On the second row, it only replaced part of the data that was in the column D.

It looks like that maybe it is limited in how many characters it does. Could that be the case?

YOU ARE AWESOME! Works perfectly!

I really do appreciate your time and efforts in helping me.

I did learn a great deal on this as well.