Excel Vbscript ASAP

进行中

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

Pre-condition:

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

项目ID: #11787625

已悬赏给:

vlayausa

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条评论)
5.0

9名威客为此工作的平均竞标价是$126

MimiFL

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 更多

$50AUD 在1天里
(164条评论)
5.7
zebracaro

i can do it for you quickly and exactly

$150 AUD 在2天内
(67条评论)
5.5
customizedata

I have gone through the attached stuff. File1.txt and File2.txt 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条评论)
4.0
narsim3128

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条评论)
3.3
graphicaa

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条评论)
2.6
MinaBoushra2014

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条评论)
0.7
denopaul98

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条评论)
0.0
carmenne

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

$45AUD 在1天里
(0条评论)
0.0
Nbabita

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条评论)
0.0