from Excel VBA to acucobol

Never tested it.

I think PivotTables are handled the same way like Sheets.

The Pivot Cache is in the Workbook and handled in an Array.

So the Levels are:

1. Workbook

2. PivotCaches

3. PivotCache

My first test would something like

modify ActiveWorkbook.PivotCaches(1).Refresh

If this dosn't work i would break it down...

inquire HandleWorkbook PivotCaches HandlePivotCaches

inquire HandlePivotCaches ITEM(1) HandlePivotCache

modify HandlePivotCache Refresh()

Maybe you can look at this older thread which is also on the Excel code conversion issue.

https://community.microfocus.com/microfocus/cobol/extend_and_acucobol/f/20/t/8931.aspx

_____________________________________________________

TAGS: Excel Reading   Excel Conversion