save macro from Access Point to server or personal machine

Anonymous — Tue, 13 Jan 2015 20:02:46 GMT

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

topic save macro from Access Point to server or personal machine in QlikView

save macro from Access Point to server or personal machine