Excel Macros with ElectroNeek

A macro must be written in a .vbs file with all corresponding macro creation rules. The ‘Execute macro’ activity can then be used to run the macro.

The main difficulty for users when working with macros is that variables and methods differ between .vbs and .vba formats. It is not possible to copy and execute a .vba script in Studio Pro. Even if the .vba format looks much easier than the .vbs format in use, the functionality of .vbs is similar to the .vba script.

When working with macros in MS Excel, there are several approaches, for example, the built-in Excel functionality involves creating macros, in which case they will be saved in .xlsm format. On the other hand, you can create macros separately from Excel using VBScript. Such files will have the format .vbs. Studio Pro supports such macros.

More information is available in the ElectroNeek Help Center:

How to execute .vbs-macro in the selected Excel file?

1 Like