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")
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.