0 Replies Latest reply: Jan 13, 2015 3:03 PM by Carlos Dominguez Canseco RSS

    save macro from Access Point to server or personal machine

    Carlos Dominguez Canseco

      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