Expanding by worksheet

[Former Member]

EPM 10 NW SP15

Hi,

I am familiar with EPM API  to trigger workbook expand and refresh.  I am adjusting my 7.5 EVDRE workbook to execute in EPM10.

My book has 5 worksheets and i want my worksheets to be expanded in order - one after the other.

So far I have seen the api to expand as

EPMApi.RefreshActiveWorkBook   or  EPMApi.ExpandActiveWorkBook

Is there an api to expand in sequence similar to

Sheet1().Select

EPMApi.ExpandActiveSheet

/after done

Sheet2().Select

EPMApi.ExpandActiveSheet

//after done

Sheet3().Select

EPMApi.ExpandActiveSheet

~Dilkins

[former_member186338]

Hi Andrew,

There is no special API to provide a sequence of worksheets to refresh, but your code is more or less ok.

May be

Shhet1.Activate is better.

You can write your function to enumerate worksheets and execute ExpandActiveSheet in the loop.

B.R. Vadim

[former_member186338]

Something like:

Dim wsh As Worksheet

For Each wsh In ThisWorkbook.Worksheets 'loop in the screen order

wsh.Activate

EPMApi.ExpandActiveSheet

Next wsh