• Not Answered

How to troubleshoot Operate script that is not working?

We are running DeltaV version 14.3.1 with Operate not Live graphics.   On one of our graphics is a link to and Excel spreadsheet. 

The exact script is

Private Sub Bitmap2_Click ()

Dim hWnd

On Error GoTo ErrorHandler

ShellExecute hWnd, "Open", "Excel.exe", "Spreadsheetname.xls","\\computername\DVData\foldername\", 4

Exit Sub

ErrorHandler:

frsHandleError

End Sub

The link has been working since the project and report were created.   All of sudden it quit working.   I can still call up the report if I go to Excell by exiting Operator, opening Excel from the desktop, and click on Open file in Excel with the same name as the script.   Nothing has been done to the system for it to stop working.   No changes to the graphic, the script, no patches to DeltaV or Excel or any other software on the machine.   This is on our ProPlus.   It is a local system - no connection to the outside world.  Any suggestions on how to troubleshoot?   No error messages happen.   It just fails to open the spreadsheet on a click as it has been doing.  Everything else on the graphic is still working.   This is the only Excel link to a report we have on any of our graphics in the system.

1 Reply

  • Never mind. Nothing wrong with the script/DeltaV. It was Excel. Updated and got the link to work again. Never did find any error messages anywhere.