topic Re: Macro in QlikView

Macro

smilingjohn — Thu, 12 Mar 2015 06:40:18 GMT

HI All

Iam exporting a straight table to excel and in excel i want to colur yellow column D and Column F

how do i mention the code in the macro for this ?

My Code :

sub ExportToExcel_Ration

Dim CLApp, XLDoc,XLSheet

set XLApp = CreateObject("Excel.Application") ' Define Object

XLApp.Visible = True 'Visible set as true

set XLDoc = XLApp.Workbooks.Add 'Open new workbook

set XLSheet = XLDoc.Worksheets.Add

ActiveDocument.GetSheetObject("CH04").CopyTableToClipboard TRUE

XLSheet.paste

XLSheet.Name="Ration"

End Sub

Thanks in Advance

Gysbert_Wassenaar — Thu, 12 Mar 2015 08:29:39 GMT

'Change the background colour of column A to a light yellow
objExcel.Columns(1).Interior.ColorIndex = 36

smilingjohn — Thu, 12 Mar 2015 09:57:37 GMT

Hi Gysbert

I tired it it now working

Iam using the same macro what i posted above and to that in the last row i added ur code but its not running

Gysbert_Wassenaar — Thu, 12 Mar 2015 10:05:23 GMT

Of course it won't run if you blindly copied that line. Your code doesn't create an object with the name objExcel.