Running macro without launching Excel everytime

[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