3 Replies Latest reply: Aug 28, 2011 12:00 AM by ncm ozkan RSS

    Excel macro sorting

    ncm ozkan
      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()"