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

ID de 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)