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

Навички: Excel

Показати більше: 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

Про роботодавця:
( 5 відгуки(-ів) ) Sydney, Australia

ID проекту: #11787625



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 за 1 день
(66 відгуків(-и))

9 фрілансерів(-и) у середньому готові виконати цю роботу за $126


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 Більше

$50 AUD за 1 день
(164 відгуків(-и))

i can do it for you quickly and exactly

$150 AUD за 2 дні(-в)
(67 відгуків(-и))

I have gone through the attached stuff. [url removed, login to view] and [url removed, login to view] 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 Більше

$160 AUD за 3 дні(-в)
(12 відгуків(-и))

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 Більше

$83 AUD за 2 дні(-в)
(14 відгуків(-и))

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 Більше

$263 AUD за 10 дні(-в)
(3 відгуків(-и))

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 Більше

$30 AUD за 0 дні(-в)
(1 відгук)

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 Більше

$200 AUD за 3 дні(-в)
(0 відгуків(-и))

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 Більше

$155 AUD за 3 дні(-в)
(0 відгуків(-и))

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

$45 AUD за 1 день
(0 відгуків(-и))