VB Macro to change the EPM Workbook Report Connection

[rajkumar_kandula]

Hi All,

I am trying to write a Excel macro to change the EPM workbook connection from Server1 to Server2. I am almost succeeded but somehow got stuck with below line of code

epm_api.ChangeReportConnection Application.Workbooks(k).Sheets(i), _ reportnames(h), newConn

Somehow macro is throwing me an error at this line. I have checked the syntax & all other parameters but not able to succeed. Any pointers how to proceed or is there any other function/way to change the workbook connection without using this ChangeReportConnection api.

Let me know if you need any further details to help me out here. Thanks in advance for your support.

Regards,

Raj