copy/paste report with a macro.

[Former Member]

Hi all,

I want to know if a macro VBA able to copy/paste a report (the equivalent of report action --> Copy report / Paste report) exists ?

Thank you in advance.

[Former Member · Accepted solution]

Hi roberto,

It's an bpc 10 request

I want to copy-paste an epm report with a VBA macro in another sheet in the same workbook.

[former_member186498 · Accepted solution]

Hi Fabrice,

with a button try

Sub Button1_Click()

Dim ws As Worksheet

Set ws = ThisWorkbook.Worksheets("Name of the Sheet You want to copy")

ws.Copy ThisWorkbook.Sheets(Sheets.Count)

End Sub

Regards

     Roberto

[Former Member · Accepted solution]

Thanks.

I have used this procedure and It works perfectly.

But I thought that a specific epm macro manage this feature.

[former_member186498 · Accepted solution]

Hi Fabrice,

But I thought that a specific epm macro manage this feature.

I don't think it exists, and the upper code works also for no BPC sheets .

Regards

     Roberto

[former_member186498]

Hi Fabrice,

this is not a BPC request so maybe it's better to look in microsoft site.

What do you want to copy only a worksheet or the entire workbook?

If a worksheet inside the same workbook or in another one?

Regards

     Roberto