I think that it would be a great idea to build into Studio the ability to store VBScript in a variable and then be able to execute it against Excel. The VBScript should be able to accept variables from within Studio. I know that we can write external files and execute them, but doing it within Studio would keep from having to save multiple local files. It would also keep any curious users from modifying the local saved script. Executing VBScript would allow developers to make modifications within the Excel file without having to use screen connectivity. Some of these modifications would be: adjust cell width, add headers, copy special, group, etc.
Would be like “Call A Macro” but the code lives outside of Excel?
You can search for this activity with the latest packages installed:
And then see it in action yourself