Excel VBA script to call macro and write values in specified excel sheet
Goal: create a VBA script to write data into specified cells in microsoft excel.
What needs to be done: download enterprise imacros and follow instructions to set up the macro with vba script.
Details: We can provide most of the code for the macro, which is easy using the software. The more complicated part is setting up the calling script.
The macro will extract text from a website (see diagram below). The text will need to be called by Excel script to extract the data. The script will then insert extracted texts into specified cells.
An step by step example of the calling of the macro which was extracting different data can be seen here:
http://www.iopus.com/imacros/excel.htm
http://forum.iopus.com/_uploads/ExcelVBA-Part1.htm
http://forum.iopus.com/_uploads/ExcelVBA-Part2.htm
an example of the code used can be seen here:
http://wiki.imacros.net/Excel-VBA-StockSearch
The software for the macro can be downloaded and used free for 30 days here: http://www.iopus.com/imacros/
Data for testing extraction can be found here.
