topic Re: Excel macro sorting in QlikView

Excel macro sorting

Fri, 26 Aug 2011 04:35:23 GMT

I have a VBScript in Qv like below calling an excel macro in which there is a sorting function. This excel macro runs without any problem in MS Excel. However, when Qv calls this this excel macro (like below), sorting function in it does not work. Any idea?

Set objExcel = CreateObject("Excel.Application")

objExcel.Visible = True

Set objWorkbook = objExcel.Workbooks.Open("path\test.xlsm")

objWorkbook.Application.Run "macro()"

Excel macro sorting

Fri, 26 Aug 2011 10:12:19 GMT

Hi,

In the macro script module did you set "Module Security" to allow system access? Please check.

If you set and still not working post the sample app with excel.

Cheers.

Excel macro sorting

m_woolf — Fri, 26 Aug 2011 11:11:32 GMT

Try something like this:

objWorkbook.Application.Run('test.xlsm'!macro)

Re: Excel macro sorting

Fri, 26 Aug 2011 13:55:30 GMT

Didnt work. Any way, I moved the sorting function to Qv. The problem fixed, for now. For your info, I can run the macro. The only problem is the sorting part inside the macro. When the macro is called externally, like by Qv, the sorting function in it is neglected.