VBScript Excel string manipulation. Adding to existing working Macro.


I worked for many years in I.T, and as part of my role I learned VBScript. I left I.T around 6 years ago, and over time I have continued to write scripts to help in my business. Now I am lacking time to write the VBScript, so I am looking for an experienced VBS programmer to help with some changes to an existing VBScript. I am rusty with not using my VBS skills, and I am finding that it is too slow going!

I have an existing VBScript for Excel that takes data from an Excel worksheet, and then manipulates the data by removing and sorting columns, and also modifying data in the spreadsheet.

The columns are formatted perfectly, and now there is some additional string manipulation needed.

Example of string manipulation within For loop

- Check each cell in a column, and modify then extract data from address string


"123 Example Street,

San Roque,



Philippines, The"


- Change 'Philippines, The' to 'The Philippines'.

i.e If there is ", The" in the string remove ", The" and add "The " in front of country

- Extract location with state.

e.g in the example above extract location as "San Roque, NCR"

- Extract country name and write to a cell

Full instructions will be provided once the candidate has been accepted.

Some of the VBS functions that you should be familiar with:

Left, Right, Replace, InStr, InStrRev

I am looking for someone with good experience with writing VBScript macros in Excel, who works quickly and know what they are doing.

On selection of the right candidate I will provide the existing XLSM file along with example data to work with.

Taidot: Visual Basic, Excel, tietojenkäsittely, Excel Macros

Näytä lisää: open xml vbscript excel, vbscript find string file, vbscript search string excel, vba string(), vba instr, vba replace, vba concatenate string and integer, vba string functions, vba split, vba truncate string, vba string manipulation, vbscript excel search string file, vbscript finding string excel sheet, string manipulation macro excel, vbscript excel example sql server connection string, vbscript excel connection string, excel string manipulation, excel string manipulation substitute, vbscript excel macro started, vbscript search string excel find

Tietoa työnantajasta:
( 1 arvostelu ) Watsons Bay, Australia

Projektin tunnus: #26931354

Myönnetty käyttäjälle:

(61 Arvostelua)

10 freelanceria on tarjonnut keskimäärin 159$ tähän työhön

(802 arvostelua)
(170 arvostelua)

Hi Michael. I am a Excel macro and vba developer with 9+ years of experience. I have worked on several similar projects create and combining multi macro functions and can deliver quality notes to tight deadlines. You c Lisää

$250 AUD 2 päivässä
(7 arvostelua)

I'm an Excel/Excel VBA expert with rich experience in Excel/VBA application. I read the job details extremely carefully. I am absolutely sure that I can do this project very well. I'm ready to do it now. I will wai Lisää

$100 AUD 1 päivässä
(1 arvostelu)

Hello I have just saw your project and it's very cool to work over there we have 500+ trusted clients please give a chance to work on your project inbox me for further details

$100 AUD 2 päivässä
(0 arvostelua)
$156 AUD 3 päivässä
(0 arvostelua)

I'm developer since long and solving such problem almost on regular basis,, on few prestigious site ,, and I'm confident enough that I can handle & fix it,,, but on other side I also need complete information,,, what Lisää

$150 AUD 5 päivässä
(0 arvostelua)

I am a professional with all the experience and skills for project. Data Entry is one of the skills we have and can help you with the project as per your project.

$140 AUD 7 päivässä
(0 arvostelua)

MOSTLY I DONE EXCEL SHEET PROCESSING AND AUTOMATION USING MACRO. If you give chance I assure, i will do my best to finish your job as per your requirement. Thank you Relevant Skills and Experience I done excel sheet p Lisää

$89 AUD 3 päivässä
(0 arvostelua)