Excel Vbscript ASAP

Scan through the text files and retrieve the words next to "FROM" and "JOIN" words and put into Excel


1)Use Excel Vbscript

2)In scripting refer to excel cell using Cells method NOT Range method

Example: Use this way "Worksheets("Sheet1").Cells(1,1)"

Steps to do:

1)Scan through the text files [url removed, login to view] and [url removed, login to view]

2)Get first word after "FROM" and "JOIN"

3)Remove duplicate values

4)In file [url removed, login to view], don't select words "[" and "(SELECT" after the JOIN

5)Step2, Step3 and Step4 should be in seperate methods

Fore more clarity, refer to attached word docs, where color blue should be in excel cell and color red should be avoided

Also provided sample excel file which I'm expecting after the scripting

Habilidades: Excel

Ver más: vbscript remove duplicate values text file, vbscript excel find, datasource vbscript excel, vbscript excel text sheet, user vbscript excel, odbc vbscript excel, vbscript excel search string file, vbscript excel read file update save file database, open internet explorer vbscript excel, odbc connection vbscript excel, vbscript excel connect sql server, vbscript excel pivot, vbscript excel addition, vbscript excel merge, open xml vbscript excel, search vbscript excel

Información del empleador:
( 5 comentarios ) Sydney, Australia

Nº del proyecto: #11787625

Adjudicado a:


Hello, I am proficient with Excel and VBA and I would love to help you with this project. I fully understand your requirements. It sounds quite simple for me. Please contact me for more information.

$40 AUD en 1 día
(66 comentarios)

9 freelancers están ofertando el promedio de $126 para este trabajo


Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel macros and i've never had a single problem. If you are interested message me and i will be more than happy Más

$50 AUD en 1 día
(164 comentarios)

i can do it for you quickly and exactly

$150 AUD en 2 días
(67 comentarios)

I have gone through the attached stuff. [login to view URL] and [login to view URL] looks like a data from sql joins query.I can do all 5 points using Excel VBA. 1- Which produce the output as specified in "Sample Output file". 2- Wi Más

$160 AUD en 3 días
(12 comentarios)

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 6 years of experience. I have successfully completed few projects for US clients which involved web sc Más

$83 AUD en 2 días
(14 comentarios)

Greetings, This is GOPAL for STALLIONi, Let me assist in this. Best results & optimum cost guaranteed here. Now, I am available for live chat. If you are convenient - now we can discuss more about this project. O Más

$263 AUD en 10 días
(3 comentarios)

Hello I am engineer with more than 5 years experience in excel and word and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expecta Más

$30 AUD en 0 días
(1 comentario)

Hello Sir/madam, I have been working with excel and data entry from last 6 years. if you give me the chance for completing the project. you will definitaly fine the 100% accuracy and the best timing. sir, if you wa Más

$200 AUD en 3 días
(0 comentarios)

I am a talented and experienced Data Entry Operator. I have good experience with Data Entry and I have been working as a Data Entry Operator for the Aga Khan University Hospital and as a freelancer for many years. I am Más

$155 AUD en 3 días
(0 comentarios)

I have experience in Excel (including VBA) and also coding skills (C#). I am looking forward to this task.

$45 AUD en 1 día
(0 comentarios)