Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

cdominguez
New Contributor II

save macro from Access Point to server or personal machine

save macro from Access Point to server or personal machine

Such a good afternoon, what I want is that from the ACCESS POINT run my macro, its function is to generate QVDS but do not put that route for the QVD is saved on the server or on my personal machine.

the macro runs perfectly on my personal computer. But in the access point does its function.

thank you very much for the support.

Sub ExportCambiosProductos

  set temp = ActiveDocument.GetApplication.GetProperties

  set doc = ActiveDocument

  vUser = Replace(temp.UserName, "\", "_")

  vDate = ActiveDocument.Evaluate("=Date(Now(),'DDMMYYYY_hhmmss')")

vPath = "C:\Users\cdominguez\Documents\Proyectos QV\pruebas\QVDs\"<------------I need a route please

vFileName =  vPath & "ActualizacionQVD_"&vUser&"_"&vDate&".qvd"

set Graph = ActiveDocument.GetSheetObject("CH_ExportCambiosProductos")

Graph.ExportEx vFileName, 4

msgbox("Autorización Realizada")

End Sub