Search results for query: *

I'm working with a locked down external plugin (Cognos Analyst) for Excel. One of the functions it has is to create a shape (drawing object) and assign one of the XLA's macros to it. The XLA is password protected. The macro that is run when you click the button is "Analyst_SaveButton". This...

That's the problem. The code for the macro is locked behind a password protected XLA file. That's why I want to simulate a textbutton being pressed. The textbutton has no code behind it besides to call the macro in the password protected XLA file. The macro picks up whatever the text is in...

I'm trying to program a VBA script to execute a macro from an Excel Plugin (Cognos Analyst). When I use the plugin to assign the macro (Analyst_SaveButton) to a text button, it stores what I assume is the parameter value in the text of that text button. Clicking the button then executes the...

I'll try posting there too. I didn't post there initially since the Analyst_SaveButton macro is a part of the Cognos Analyst plugin. It's stored in an XLA file. The issue is that the XLA file is locked.

thread401-1156378 I'm trying to program a VBA script to automatically update data in an Analyst Cube and save it. The problem comes with attempting to save. The Analyst_CubeSave macro in the Excel Plugin prompts for which Cube to save. I saw someone had the following code using the...