I am getting this error
'1129: OleInitiate: Initiate Failed'
when debugging my script. THe line that causes it is
objExcel = ObjectCreate("Excel.Application")
If I compile the script and run it as admin, the executable works. when i run it without clicking 'as admin' it appears to stall at about where this line of code occurs. The problem started when they performed an in place upgrade from Windows 2012 R2 to Windows Server 2019. I tried upgrading WinBath to 2022A but that did not help the problem. I also tried repairing Excel. I think Im going uninstall excel and reinstall it.
The first thing to identify is the bitness of your Office products. Are they 32-bit or 64-bit? If they are 64-bit, then you will have to compile your script using the 64-bit compiler.