Mass Find & Replace Script?

**TyneeTom** · 04-23-2009, 02:16 AM

Hey guys.....I hope I can do a decent job explaining what I need done here.

I run a website that sells over 4700 Health & Fitness items.

I upload information via a .CSV table.....

Every month my supplier sends me an .XML that tells me what products have been discontinued.

I basically am looking for a more efficient way to updating my tables, rather than going one by one...(this could take hours)

What should my script look like for a massive Find & Replace?

Thanks in advance, much appreciated.

I found this.......is this related to what I want?

http://www.excelforum.com/excel-prog...d-replace.html

*edit*

Here is a link to my discontinued csv and my website's csv.

http://site.tyneetom.com/DiscontinuedSkusCumulative.csv

http://site.tyneetom.com/TyneeTomBoth2April20093.csv

Thanks in advance.

**Mallycat** · 04-23-2009, 02:29 AM

If you can post some sample files, I am sure someone will write a simple macro for you

**TyneeTom** · 04-23-2009, 03:13 AM

Thanks Mally, just updated my post.

**Mallycat** · 04-23-2009, 08:09 AM

Give this a try.

follow the instructions inside.

Note it assumes only one entry can be found, but I notice sometimes there are 2 entries. You can simply run it twice to delete second entries.

**TyneeTom** · 04-23-2009, 05:05 PM

Hey Mally,

Thanks for this!

Am I suppose to do anything with "Sheet2" and "Sheet3"? Those pages are empty.

I'm also getting this error....I've already tried re-installing my Microsoft Excel.

http://i5.photobucket.com/albums/y18.../Macrofail.gif

I'm using 2007 Excel if it makes any difference, I've also already checked, I have macros enabled.

http://support.microsoft.com/kb/930076

**Mallycat** · 04-23-2009, 10:14 PM

No, just ignore sheets 2 and 3.

I have no idea why the macro isn't running. Try running it from the menu (Developer\Macro) and see if that works.

Note I have not put any error checking in this. If you have more than the prescribed files open, it may not work. If you have less than the 3 files open, it also wont work. If you rename DiscontinuedSkusCumulative.csv or deletions.xlsm it wont work. It is ok to rename the third file without any issues.

Hope you can get it to work.

**TyneeTom** · 04-23-2009, 11:26 PM

Oh my god, Mally CAT.

Thanks! This really helps a lot!

It works! Apparently there was a security warning I didn't see that said macros were disabled.

**Mallycat** · 04-24-2009, 03:41 AM

Great. I am glad it is helpful and what you need.

Mass Find & Replace Script?

LinkBack

Thread Tools

Rate This Thread

Display

Mass Find & Replace Script?

Re: Mass Find & Replace Script?

Re: Mass Find & Replace Script?

Re: Mass Find & Replace Script?

Re: Mass Find & Replace Script?

Re: Mass Find & Replace Script?

Re: Mass Find & Replace Script?

Re: Mass Find & Replace Script?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions