Delete a Column in Excel File. (1 Viewer)

[ian_w]

I've written a module to write data generated in Access (97) to excel.

I want to be able delete a Column if a value in a field is 0 e.g.

If xlApp.Cells(1,1).Value = 0 then
xlapp.Column("B").Delete
End if

I cannot find any examples though, only for VB.Net or for deleting Rows..

Anyone able to point me in the right direction?

 

[ian_w]

Found it

xlApp.Columns("G:G").Select
        Selection.Delete