Run Command tool not successfully executing excel macro through vb script

Question

I have a Run Command workflow.  When I run it on my local computer, works fine.  When I run it on the server Designer version it works fine and creates the expected excel file.  When I run in the gallery, it executes successfully but the excel file is not created.  The excel macro is manipulating some data and saving off a new file.  I've attached the run command image as well as the vb script code below.

I confirmed that the server isn’t restricted.  I cannot figure out why it won’t work on Gallery.

'Input Excel File's Full Path
ExcelFilePath = "C:\Test_Files\Template\Template.xlsm"

'Input Module/Macro name within the Excel File
MacroPath = "Module1.Save"

'Create an instance of Excel
Set ExcelApp = CreateObject("Excel.Application")

'Do you want this Excel instance to be visible?
ExcelApp.Visible = True 'or "False"

'Prevent any App Launch Alerts (ie Update External Links)
ExcelApp.DisplayAlerts = False

'Open Excel File
Set wb = ExcelApp.Workbooks.Open(ExcelFilePath)

On Error Resume Next
'Execute Macro Code
ExcelApp.Run MacroPath

'Save Excel File (if applicable)
wb.Save

'Reset Display Alerts Before Closing
ExcelApp.DisplayAlerts = True

'Close Excel File
wb.Close

'End instance of Excel
ExcelApp.Quit

IMG_0503.png

Brian_Denso · Answer

Fernando,

Just to follow up, I have found the solution.  It was a permission issue.  The server was setup with a default user which needed to have permissions in the COM registries.  Originally, I only fixed the issues specific to my personal login and not the default user account.

Here is the link I used to fix the permissions in case this comes up for anyone in the future.  My registries that needed permission were different from the link, but the process was the same.

How to Fix 'Application-specific permission settings' Error - Appuals.com

The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID 
{21B896BF-008D-4D01-A27B-26061B960DD7}
and APPID 
{03E09F3B-DCE4-44FE-A9CF-82D050827E1C}
to the user NA\USER SID (S-1-5-21-1289235617-2937510960-3569147640-19828) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

fmvizcaino · Answer

@Brian_Denso ,

It is clear that it is a permission issue.

If you could enable the option to Allow users to select credentials, you could use your own credential in this specific workflow.

https://help.alteryx.com/20221/server/select-workflow-credentials-setting-your-server

Best,

Fernando Vizcaino

nehakakar · Answer

You should consider using relative paths instead of full paths.

Try this!

'Get the folder path of the script
ScriptFolderPath = Left(WScript.ScriptFullName, InStrRev(WScript.ScriptFullName, "\"))

'Input Excel File's relative path
ExcelFilePath = ScriptFolderPath & "Template\Template.xlsm"