I have a process that runs Excel in batch mode with a .vbs routine. That routine takes a series of arguments (input spreadsheet, output spreadsheet, path, vba file, vba module) which automatically applies formatting to a spreadsheet.
This has worked flawlessly on another system and am trying to recreate that in a new environment. The vbs module runs and executes the vba (.bas) routine but then dies with the infamous 'Unknown runtime error':
Windows Script Host
Error: Unknown runtime error
Source: Microsoft VBScript runtime error
The one-line batch file that runs the launches excel is:
" "c:\users\ben\" "noclaims" "noclaims"
I've attached the launch.vbs routine (after renaming it to launch.txt). Line 21 is the objxl.Run command with the comment on the right 'Run VBA code.
Any suggestions on this one? I can include the noclaims routine if needed.