report using Macros

[Anonymous]

Hi

Is it possible to export the entire sheet to excel.

Thanks,

Dhivya

[Anil_Babu_Samineni]

Each report into different sheets or only one sheet with contain of all report data?

[Anonymous]

export one report containing all the sheet objects of one sheet into a excel file

[Anonymous]

If moving the report is not possible

then I want to move all the sheet objects of one sheet into excel

[Anil_Babu_Samineni]

May be try this?

Sub EXPORT

set var = ActiveDocument.GetSheetByID("SH01").Activate

var.Export "Path\MyDoc.csv", ", "

End Sub

[Anonymous]

The Macroscript opens again.

It is not opening Excel