Help! Need to get value from Excel Cells that contain specific value and store it to array then put it in certain cells.

[Ram]

Hey, i wonderin if i could get value from excel cells that contain specific characters / or value, then paste / send that value to certain cells in Excel.

CAn anyone help me ? Thankyou very much.

[TheUnknown138]

This is how you can open a workbook and copy a value onto another sheet, workbook, etc.

Code: Select all

xl := ComObjCreate("Excel.Application")
xl.Visible := true
xl.Workbooks.Open(Workbook_Name)
xl.Sheets(1).Range("A1").Value := xl.Sheets(2).Range("A1").Value
xl.DisplayAlerts := 0
xl.ActiveWorkbook.Save
xl.Quit()
xl := ""

[Ram]

thankyou very much for ur help bro!