Forum Discussion

Scott_Visio's avatar
Scott_Visio
Frequent Visitor
4 years ago

automate routine functions with VBA-like script

I’m an experienced VBA programmer and am accustomed to using it to automate many different aspects of Word, Excel, Visio, and PowerPoint. I’m starting a new project in which I’ll be creating six or ...
Need Help
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

I know but I do think there are some relevant bits from each one.

 

For example, you can duplicate reports and change data sources with PowerShell while Tabular Editor is useful for scripting edits to measures and updating column properties and relationships. Neither of these applies to pages and visuals but I don't think any single tool can cover all bases and these two may cover some of the use cases Scott_Visio is interested in, though certainly not all of them.

 

Scott_Visio's avatar
Scott_Visio
Frequent Visitor
4 years ago

Thanks for making a distinction between the best uses for PS and TE. I'm familiar with the former but not the latter so I'll take a look.

Also, I'm trying to create a way for less-technical members of my client's team to create a new report from my template. That group is less likely to be familiar with either PS or TE.