Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

error in macro in access point

I have a macro that generates Qvds on my personal computer once you make a corresponding function, but when run it on the server (access point) brand me an error that the file can only be read as writing.

Now use the IE Plugin and several macro commands and I do not its function.

  Not if my path on the server this, if anyone knows where Folder or route will be greatly appreciate it

error1.png

Sub ExportCambiosProductos

  set temp = ActiveDocument.GetApplication.GetProperties

  set doc = ActiveDocument

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

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

  vPath = "QVDs\"

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

                set Graph = ActiveDocument.GetSheetObject("CH_ExportCambiosProductos")

                

                Graph.ExportEx vFileName, 4

                msgbox("Autorización Realizada")

End Sub

1 Reply
Anonymous
Not applicable
Author

vFileName = ActiveDocument.Evaluate (vPath & "ActualizacionQVD_"&vUser&"_"&vDate&".qvd")