Dynamically Named BPC Report as a table

[Former Member]

Hello-

I am working on converting a report from BPC 7.5 to BPC 10. The report worked well in BPC 7.5 and utilized much VBA code. part of the VBA code would like at a named table ranged called "tblInput" and utilized this to add on to the report and send additional data to BPC.

The issue I am running in to, is that I am able to convert the BPC report by selecting the table and clicking Insert-> Table. At this point, excel converts the table to a "named table range" which is all good. The problem is, as I refresh the BPC report, I need the named range to dynamically expand and contract as the report grows. I haven't been able to get this to work. The best I can do is "freeze" the range, but this isn't helpful.

Is there a way to turn my BPC report into a dynamically named table that I can use and reference in VBA code?

Tom

[former_member186338]

Hi Tom,

Absolutely easy:

In AFTER_REFRESH event function you can use the following API:

GetDataTopLeftCell

GetDataBottomRightCell

to find the data range and change the named range...

Vadim