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?
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?