Problem with running excelcnv.exe or vbs script on Alteryx Server Gallery.

[PiotrGa]

Hi dear community,

I have strange problem which occurs only when I publish workflow to the gallery.

I must convert xls file to xlsx, before processing and it was achieved in the designer but using simply command run with command:

Pushd "C:\Program Files\Microsoft Office\Office16\"

excelcnv.exe -oice c:\temp\test.xls c:\temp\test.xlsx

The command was saved as a bat file (in the location where server has access to) and it is run by Command Run tool. It works with no problem through RDP and/or Server designer.

Once it is published in the gallery it run with success but no file/output is produced.

Other strange problem is when I tried to convert the file via VBS script. It also works when I run it from CMD on the server (via RDP) and when I run host workflow from server design, but I get error: -2147467238, with no desc., on the line:

Set xlObj = CreateObject("Excel.application")

I have no idea where to search for the solution, so I will be really thankful for any help.

The main case is to convert xls file to xlsx without pulling the data.

Thanks

Piotr 

[JoeS]

Hi @PiotrGa 

This could be around interaction with the desktop that Excel often needs to run programatically.

If you change the Alteryx Service setting to enable it, that should hopefully work:

Windows Services > Right Click "Alteryx Service" > Properties > Log On > Check "Allow service to interact with desktop"