Extract data from one excel file into another excel file using VBSCRIPT..
Posted on 2007-10-10
I am new to vbscript. I am trying to write a script to find few values from one excelsheet and put into another. purpose being, my first file has raw type of data so I will search data on particular criteria and put into new file well formatted.. so far I could get the value seen via msgbox,, but nothing more.. also I want scan through entire file for first file..
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\Pramod\Scripting\test1.xls")
objExcel.Visible = True
Set objWorksheet = objWorkbook.Worksheets(1)
Set objRange = objWorksheet.UsedRange
For Each objCell In objRange
objRange.find ("Vulnerabilities (").Activate
intServerOSNameROW= objExcel.ActiveCell.Row -1
ServerNameAndOS = objExcel.Cells(intServerOSNameROW,1)