When I use the DrillThrough function by VBA, I want the data to be displayed in EXCEL instead WEB.
Summary:
I can drillthrogh in adhoc ,I was able to change through the Settings whether the results were displayed on the web or in excel.
But when I use VBA calls "HypExecuteDrillThroughReport" ,data can only display on the web, I want to display data in EXCEL sheet
Content (please ensure you mask any confidential information):
I can drillthrogh in adhoc ,I was able to change through the Settings whether the results were displayed on the web or in excel.
But when I use VBA calls "HypExecuteDrillThroughReport" ,data can only display on the web, I want to display data in EXCEL sheet
0