| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VSTO - How to find all Pivot tables in the Workbook
Hi ,
I have seen a lot of examples how to find pivot tables using macro. But in C# I don't have Count property for (int i = 1; i <= this.Application.Sheets.Count; i++) { Excel.Worksheet ws = (Excel.Worksheet)this.Application.Sheets[i]; for (int j = 1; j<= ws.PivotTables.Count // ERROR How can I do it in C#? Thanks a lot Smugliy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables across sheets in a workbook | Excel Discussion (Misc queries) | |||
| Find Pivot Tables in workbook based on their name | Excel Discussion (Misc queries) | |||
| Referring to all pivot tables in a workbook | Excel Programming | |||
| Refreshing all pivot tables in workbook | Excel Programming | |||
| Pivot Tables and Cells.Find | Excel Programming | |||
Threaded Mode
