Using Excel(from VB) and Delete rows

Hi

I need to open a excel sheet , select some columns and to delete the rows , where a cell from a column is blank.
For Example I to select the columns A:D, and the rows from column A is Blank I delete all row withou look column B or C or D

I do not know to open Excel from VB and too How can I to do it ?


Thank you in Advance :ehh: :blush:

check out this Link could get u started on Excel + VB

Here is a short FAQ thread on automating an office app from VB 6. - http://vbforums.com/showthread.php?t=406640

Thank You Very Much