Excel Vbscript ASAP
This project was successfully completed by vlayausa for $40 AUD in a day.Get free quotes for a project like this
Project Budget$30 - $250 AUD
Completed In1 day
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
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online