Running macro without launching Excel everytime

[Anandhu (Anandhukrishnan V)]

I have some macro functions in an excel file. I need to call the functions often in my project. So every time i need to call a function, i have to use an excel application scope to open the macro file and then inside it use ‘execute macro’ activity. This will open and close the macro excel every time when i need to call a function.

Is there a better approach?
Can I run the macro code from somewhere else without opening the macro excel?

[GabrielMoreno]

use a workflow that reads an excel file with all the information and put it to run as soon as you start your application.

[Vijay_Tulsalkar (Vijay Kumar C Tulsalkar)]

@Anandhu

Refer this post

Execute Macro from Personal Macro Workbook

Hi all, I am trying to use the Execute Macro activity to run a macro from my Personal Macro Workbook (PERSONAL.XLSB), but I encounter an exception, which I’ve included below. My input field for Execute Macro is as follows, where “JobsheetExport” is the macro name: “C:\Users\Daniel\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB!JobsheetExport” Here’s part of the error message (if the full message helps, I can post that too): Message: The range does not exist Source: Execute macro Ex…

you cab also try UnChecking the Visible Property of the excel application Scope

[balupad14 (Balamurugan)]

Hello @Anandhu,

Can you share the functionality of the macro ? if possible.

Regards
Balamurugan.S