Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

2 Replies
mov
Esteemed Contributor III

Re: save macro from Access Point to server or personal machine

Try something like this
\\<your machine name>\C$\Users\cdominguez\Documents\Proyectos QV\pruebas\QVDs\

bestofwest
Contributor II

Re: save macro from Access Point to server or personal machine

The File is saved on Local Machine   (By IE PlugIn)....

You must share a Server Driver to Save the File (\\server\.........).

Community Browser