Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Joaquin_Lazaro
Partner - Specialist II
Partner - Specialist II

Macro that runs in Load Script but not in Reload with QMC

Hi guys:

I have a macro function with a param that works fine in Desktop Load Script but it doesn't when reload from QMC, I don't know how to solve it,

This is the macro:

function open_and_save (vFile)

open_and_save = "Inicial"

' Definir el objeto de tipo Aplicación Excel con los parámetros básicos ...

set xlApp = CreateObject("Excel.Application")

xlApp.Visible = false

xlApp.ScreenUpdating = false

xlApp.DisplayAlerts = false

' Definir el objeto libro excel y abrír el fichero ...

xlApp.Workbooks.Open vFile   

Set xlDoc = xlApp.Workbooks(1)

' Guardar y cerrar fichero, Salir de la aplicación ...

xlDoc.Save

xlDoc.Close

xlApp.Quit

' Borrar objetos libro y aplicación ...

set xlDoc = nothing

set xlApp = nothing

open_and_save = "Correcto"

end function

And this is the call to the macro

     LET vRes = open_and_save(vAttachPath);

When I run it with Desktop the value of vRes  is 'Correcto' but when QMC runs the script it fails and this text is in the log file


Error: Unexpected token: '(', expected one of: ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...

Any suggest will be appreciated

Thanks in advanced,

Joaquin

1 Reply
andrey_krylov
Specialist
Specialist

As I know it's not possible from QMS