Is it possible to automate the file uploading process which we do from data manager in BPC ? Can we automate this via a macro ? We have a requirement that a csv file named prov_2020_07 stored in a folder called /Provisions gets automatically uploaded via the macro.
I have written below line of code which triggers the upload file prompt automatically but the user still has to click browse and fetch the file and upload on server folder. Can we automate that part too ?
Sub upload() Dim cofCom As Object Dim epm As Object Dim api As Object Set cofCom = Application.COMAddIns("SapExcelAddIn").Object cofCom.ActivatePlugin ("com.sap.epm.FPMXLClient") Set epm = cofCom.GetPlugin("com.sap.epm.FPMXLClient") epm.DataManagerOpenFileUploadDialog epm.DataManagerRunPackage "IMPORT", "Data Management", "" epm.DataManagerOpenViewStatusDialog End Sub