Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Is it possible to export the entire sheet to excel.
Thanks,
Dhivya
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?
Sub EXPORT
set var = ActiveDocument.GetSheetByID("SH01").Activate
var.Export "Path\MyDoc.csv", ", "
End Sub
The Macroscript opens again.
It is not opening Excel