Is it possible to export the entire sheet to excel.
Each report into different sheets or only one sheet with contain of all report data?
export one report containing all the sheet objects of one sheet into a excel file
If moving the report is not possible
then I want to move all the sheet objects of one sheet into excel
May be try this?
set var = ActiveDocument.GetSheetByID("SH01").Activate
var.Export "Path\MyDoc.csv", ", "
The Macroscript opens again.
It is not opening Excel
Retrieving data ...