Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
mricky Absent Member.
Absent Member.
1066 views

from Excel VBA to acucobol

Does anyone know how to translate these Excel vba macro instructions to ACUCOBOL statement:

ActiveSheet.PivotTables ("My_Pivot_table"). PivotCache.Refresh

Thank you

0 Likes
2 Replies
neidingd Honored Contributor.
Honored Contributor.

RE: 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()

0 Likes
mickyhall Absent Member.
Absent Member.

RE: from Excel VBA to acucobol

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.