Delete a Column in Excel File.

ian_w

Registered User.
Local time
Today, 23:31
Joined
Jun 13, 2006
Messages
64
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?
 
Found it

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

Users who are viewing this thread

Back
Top Bottom