I got a task, with a very annoying thing to do. Every one now the problem with transfer lists or databases where numbers got a some wrong, than you need to make lists and after the list you need to compare and set the things right in the right XLS(X) and this take time, a lot of time wasted by awful boring work. I made a little program which helps you a lot with this.
My program runs a whole chosen file according a list of replace needed strings (words, numbers,...) it makes the function of "replace all" in "all workbooks" and that according a list of strings.
- Supported-Format: XLS, XLSX
======== For Devs ========
- Verison: -
- Developed in Microsoft VisualStudio2013
I think it's quiet obvious but sure why not:
- start program
- chose file with wrong numbers
- chose file with translation
- first column (A1:A999...) the wrong string
- second column (B1:B999....) the number which should replace the string to the
left
-> maybe wait till "OK" appear
-> Maybe set bigger line checking rows (pre-set to 4999 rows), lesser is no
problem. more will be ignored
- click "Do it"
-> Program works 100% automated