Skip to Content

Vba Macro for sheet generation

I have 5 reports in work book and needs to generates 10 sheets for each reports.

I need to generate the sheets using VBA macro. Can someone forward me the sample macro used for sheets copying and refresh.

When 50 sheets are copied using macro ...is it better to refresh report after all reports are copied at once? WHat will is suggested from performance point of view,

Is there any standard BPC API MACRO for sheet generation that can be used in VBA script.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 17, 2017 at 05:14 PM

    Please don't ask the same question twice! It's a bad idea...

    Add comment
    10|10000 characters needed characters exceeded