Object variable or with block variable not set- while trying to submit data

[Former Member]

Hi Gurus,

Could you share me the solution to resolve the issue?

I am getting an error "object variable or with block variable not set" while trying to submit data through an Input schedule.

I am working on SAP BPC 7.5 NW and using MS Excel 2007.

I can log in to BPC Admin and excel with my user id and password.

I checked my security profile and i have the submit data task in my task profile. My all other Input Schedules are working very well. Only one of the IS is causing this problem. The same input Schedule when saved as Dynamic Template it works well and data is sent successfully.

Regards,

KumarMG

[Former Member · Accepted solution]

Hi Kumar,

This might be incase you have some special character like & in the input schedule template. you need to remove the special character in that case.

Hope this resolves your issue.

Rgds,

Poonam

[Former Member · Accepted solution]

Hi Poonam,

Thanks for the timely help. Really it was helpful and you deserve all the points.

Regards,

KumarMG