topic Re: Macros connection with Button Object in QlikView

Macros connection with Button Object

Tue, 26 May 2015 11:48:18 GMT

Hi All,

I am quite new on Macros, and with the Qlik community help i could make one macro format but i am still not able to run it properly.

As shown above when i click on test its giving me oproper results as required howveer when i click on Button in Red (Macro Testing) it does not give me anything.

Kindly help what is the process to link this macro to my button

Regards

Re: Macros connection with Button Object

robert_mika — Tue, 26 May 2015 11:56:26 GMT

Do you have "CH01" within your objects?

Could you post the whole code not a screen shot?

Re: Macros connection with Button Object

Tue, 26 May 2015 12:15:03 GMT

Yes, I do have one chart named as CH01

please find the Macros scripting below;

Sub ExcelExpwCaption

'Set the path where the excel will be saved

filePath = "U:\Group Operations HQ\Qlik View Application\Macro Testing\Test.xls"

'Create the Excel spreadsheet

Set excelFile = CreateObject("Excel.Application")

excelFile.Visible = true

'Create the WorkBook

Set curWorkBook = excelFile.WorkBooks.Add

'Create the Sheet

Set curSheet = curWorkBook.WorkSheets(1)

'Get the chart we want to export

Set tableToExport = ActiveDocument.GetSheetObject("CH01")

Set chartProperties = tableToExport.GetProperties

tableToExport.CopyTableToClipboard true

'Get the caption

chartCaption = tableToExport.GetCaption.Name.v

'MsgBox chartCaption

'Set the first cell with the caption

curSheet.Range("A1") = chartCaption

'Paste the rest of the chart

curSheet.Paste curSheet.Range("A2")

excelFile.Visible = true

End Sub

Re: Macros connection with Button Object

robert_mika — Tue, 26 May 2015 12:25:52 GMT

It does work for me

Please see attached.

Make sure that your "Macro name" under "Action" in the "Button properties" is the same as the name of the Module.

I see that there is space after the Macro name in VBS Editor