Accessing Cube fields using Office script

Question

Hi - I need to convert some VBA code to Office Script to provide functionality to web users. Specifically, I am manipulating cube fields. Any and all help is appreciated on how to access a cube and cubefields using Offcie script, but as an example, I have this code from VBA which adds a field called OppGeointo my Pivot Table called Analysis_Pvt. The field comes from the Table Opp_T

With ActiveSheet.PivotTables("Analysis_Pvt").CubeFields("[Opp_T].[OppGeo]")
.Orientation = xlRowField
End With

Is this possible in Office Script?

Answer 1

Hello,

Thank you for posting here in Microsoft Community.

I understand that you have a query about converting VBA code. While I would love to assist you with this, I'm afraid that this is beyond my expertise and out of the scope of our support.

However, I would like to suggest that you try posting your query on Stack Overflow. It is a community-driven platform where developers and programmers can ask and answer technical questions related to programming languages, including VBA.

The reason why I suggest Stack Overflow is that it has a large community of experienced developers who can provide you with accurate and detailed answers to your query. Additionally, Stack Overflow has a vast library of previously answered questions that you can browse through to see if your query has already been answered.

Here's how to post a question on Stack Overflow:

• Post VBA programming questions to Stack Overflow by using the vba tag, along with any other relevant tags.
• Please note that Stack Overflow has guidelines such as requiring a descriptive title, a complete and concise problem statement, and sufficient details to reproduce your issue. Feature requests or overly broad questions are considered off-topic. If you're a new user, visit the Stack Overflow Help Center for more information.

Also I will keep this thread open in any thread open in any case other community members have their inputs on this.

I hope this information helps.

Regards,

Arquel C.

Microsoft Moderator