VBScript to find/replace series of keywords in Excel 2003?
Posted on 2008-10-08
I have an excel spreadsheet that's essentially a checkout report. Before feeding it into our financial reporting module, I have to basically find/replace all the names of the states/countries, etc, which usually takes a good ~2 hours since we're fairly global.
I'm sure there's probably a way to script this using VBScript or something similar to say
"IF $Cell = 'United States' SET CELL = 'US')
ELSEIF $Cell = ('Australia' SET CELL = 'AU)
Only I've never written a lick of VBScript. I come from a PHP/MySQL background, though I did do some vb 6.0 some years ago, (its been quite awhile) and a bit of C#. Maybe someone with more experience in this area could point me in the right direction on how to go about accomplishing this task?