Pass parameters from excel to BI Publisher report

Summary

Pass parameters from excel to BI Publisher report

Content

Hi,

I run BI publisher report directly from excel by using soap and it works ok as long as i don't use any parameters. how can i add parameter to my soap code ? ( below is the main soap code )

 

reportBytes = f_execWsSoap("/Custom/Logistics/Inventory/Reports/On Hand Inventory Balance.xdo")

Public Function f_execWsSoap(ByVal reportAbsolutePath As String, Optional ByVal parameterNameValuesXML As String)
    Dim sURL As String
    Dim sEnv As String
    Dim base64reportBytes As String
    Dim reportBytes As String
    Dim httpReq As New XMLHTTP60
    Dim Response As String