How to delete rows in exported excel using macro?

Fri, 20 Nov 2020 18:02:30 GMT

I have written a macro to export tables to a single sheet and it works fine. But I want to delete few specific rows and cells in the exported excel. How do I define it in a macro staticly?

Re: How to delete rows in exported excel using macro?

vardhancse — Tue, 02 Dec 2014 05:29:11 GMT

what ever fields are not required can be de selected and can run the macro...

Re: How to delete rows in exported excel using macro?

aworrall — Tue, 29 Jan 2019 11:28:08 GMT

I know this is an old thread but for me it was as simple as using

XLSheet1.Columns("A:E").Delete

in my macro VBA in Qlikview to remove those columns

eg - extracting a table to excel, formatting and removing some columns

sub test1

SET XLApp = CreateObject("Excel.Application")

XLApp.Visible = true

SET XLDoc = XLApp.Workbooks.Add

SET XLSheet1 = XLDoc.Worksheets(1)

'Table export

ActiveDocument.GetSheetObject("CH77").CopyTableToClipboard (true)

XLSheet1.Paste XLSheet1.Range("A1")

XLSheet1.Name = "E200 - Salary"

'AutoFit All Columns on Worksheet

XLSheet1.Columns("H:H").ColumnWidth = 80

XLSheet1.Columns("G:G").ColumnWidth = 80

XLSheet1.Columns("A:E").Delete

XLSheet1.Range("E1").Activate

XLSheet1.Range("A1").Select

XLSheet1.Cells.Select

XLSheet1.Cells.EntireColumn.AutoFit

XLSheet1.Cells.EntireRow.AutoFit

XLSheet1.Columns("E:E").Select

XLSheet1.Columns("E:E").Style = "Comma"

XLSheet1.Range("A1").Select

end sub

topic Re: How to delete rows in exported excel using macro? in QlikView

How to delete rows in exported excel using macro?

Re: How to delete rows in exported excel using macro?

Re: How to delete rows in exported excel using macro?