Emerson Exchange 365

DeltaV Excel Add-in

Hi, has anyone any experience using the DeltaV Excel Add-in to AUTOMATICALLY write values to a module? without having to click the manual update button in the menu bar? if so I would be interested in seeing your vbscript. I've copy and modified the DeltaV Excel Add-in vba code and am having some intermittent issues.

1) A message about having no time interval set, so a default of 0 will be used.

2) A message about having no cells selected that contain DeltaV write functions. I seem to get this if I save my excel spread sheet with a range a cells selected that don't contain the DeltaV write function.

Stuart Jolley

• 5 Jun 2014 4:34 PM
• Cancel

45 Replies

• timalg

  

  • 14 Aug 2020 8:13 AM

  In reply to LaurentB:

  Hi Bruno,
  I dont have experience with macro and codes
  I brought the deltav.xla from another server which do the same task creating excel report and they have name,can this be the reason of no updating of deltav.xla ?

  • Cancel
• timalg

  

  • 14 Aug 2020 8:18 AM

  In reply to LaurentB:

  sometimes when I try to open the file deltav.xla I get message that this file is already open and can not open 2 files

  • Cancel
• timalg

  

  • 14 Aug 2020 8:28 AM

  In reply to LaurentB:

  do Ifix background server must be running for transferring data?

  • Cancel
• timalg

  

  • 14 Aug 2020 11:56 AM

  In reply to LaurentB:

  Hi Laurent,
  I brought the deltav.xla from another server it does the same action creating excel report .sometimes when I try to open the deltav.xla i get error message can not open the the file is already open.can this be the reason of no updating deltav.xla link?

  • Cancel
• LaurentB

  

  • 14 Aug 2020 12:27 PM

  In reply to timalg:

  do you mean that sometime that's work ? Have a look on windows process to see if you don't have a lots of instance dvxlsserver ? If yes kill all of this instance before runnng yuo excel scheet with XLA

  • Cancel
• timalg

  

  • 14 Aug 2020 12:39 PM

  In reply to LaurentB:

  Hi Laurent,
  I mean when I mean when I try to open the deltav.xla without opening the excel sheet I get message error that the deltav.xla is already opened.
  So I understand that the instance dvxlsserver starts when I open the excel sheet.is it true?
  Also the issue starts when we stopped delta v service and we start it again and Ifix background server stopped.i used opcwatchit and find opc.delta v running good.i suspected deltav.xla so I copied it from an other server

  • Cancel
• timalg

  

  • 14 Aug 2020 2:45 PM

  In reply to LaurentB:

  Dvxlsrv.exe doesnot start when i open deltav.xla or the excel sheet .but when I open a normal excel sheet which contains the two icones of delta v it starts

  • Cancel
• BillS

  

  • 14 Aug 2020 4:10 PM

  I represent SyTech, Inc. , a partner of Emerson.  Our product XLReporter takes data from "live"/history to produce reports as Workbooks. PDF or Web Pages automatically. No installation of Excel is required.  See https://www.sytech.com/solution-report-from-emerson-process-management.asp or contact me for more information and an evaluation.

  • Cancel
• timalg

  

  • 15 Aug 2020 11:43 AM

  In reply to LaurentB:

  Hi Laurent,
  In the excel worksheet there is an function called DvCHvalue, please I would to know how this function grapps the data.is there a way if this function is running well?

  • Cancel
• timalg

  

  • 15 Aug 2020 8:58 PM

  In reply to Lun.Raznik:

  Hi Lun,
  How the function DvCHvalue in the deltav.xla collect the data .do this function uses data base?

  • Cancel
• timalg

  

  • 16 Aug 2020 7:05 AM

  In reply to LaurentB:

  Can this problem due to stopping the delta v service?
  I brought a backed up excel worksheet and used it ,it generates automatically the report(we used two methods to generate the report manually and automatically) but not all reports were generated(we have 4 different reports each report is related to a different field). I tried to reboot the server then when the report tried to be generated automatically again I got the message error about the links

  • Cancel
• timalg

  

  • 16 Aug 2020 11:48 AM

  In reply to BillS:

  Hi Bill's,
  Thank youWe will upgrade our system as soon with emerson and we will maybe install delta v explorer.i need a solution am stuck now

  • Cancel
• timalg

  

  • 16 Aug 2020 12:43 PM

  Hi Laurent,
  Thank you for your help in the excel worksheet there is an function called DvCHvalue, please I would to know how this function grapps the data.is there a way if this function is running well?
  

  Regards

  Khaled zikara

  
  

  Envoyé à partir d’Outlook
  

  
  

  ---

  De : LaurentB <bounce-LaurentB@emersonexchange365.com>
  Envoyé : vendredi 14 août 2020 08:02
  À : DeltaV@emersonexchange365.com <DeltaV@emersonexchange365.com>
  Objet : [EE365 DeltaV Forum] RE: DeltaV Excel Add-in

   

  Update from Emerson Exchange 365 LaurentB In old version version DeltaV Writes function is accessible into VBA project on XLA . Find deltav Writes function ( remove the msg box code lines) Create your own macro to run the "modified DeltaV Writes function" , but in your code before running the DeltaV Write , in yuor code you have to select all the cells Sheets("Feuil1").Select Cells.Select frs.deltavwrites also how delta v continuous historian send data to the excel file => it 's more accurate to say How Excel can read into DV Continous historian Do to this you have to install DeltaV Excel reporter which install also addins into Excel like excel addin. In most recent version of DeltaV , DV Reporter installer is on DVD disk 1 In older version of DeltaV , DeltaV Continuous Historian was build on PI , so PI datalink was working , but less powerfull to create scheduled task View online   You received this notification because you subscribed to the forum.  To unsubscribe from only this thread, go here. Flag this post as spam/abuse.

  • Cancel
• Andre Dicaire

  

  • 16 Aug 2020 8:18 PM

  In reply to timalg:

  Lots of questions in this thread.
  
  The XLA is an Excel Addin and you do not launch this a s a program. It is loaded into Excel to provide those DeltaV read and write functions.
  
  Excel add in use OPC server to connect to the DeltaV run time comm layer. It expects to be o a Deltav node and does not install if the deltav registry keys are not present.
  
  The excel addins connect either to the OPC server or to the Continuous Historian to retrieve data. there is no additional database. The calls to DVCH(DeltaV Continous Histoiran) use API calls and not OPCHDA or OPCDA. These calls include functions of the historian to return averages, Min Max values, which come from the historian and not calculated in excel.
  
  The Excel add ins do not use iFIX, though this service is running on DeltaV nodes.
  
  Something to understand is that DeltaV Excel Addin requires the PC to have a licensed OPC DA server. If you move the Excel sheet to a computer without a licensed OPC server, the add in will not work.
  
  The DVREAD and DVWRITE functions added to Excel activat the OPC client of the Add in and connects to the OPC server Which connect to the DeltaV Communication layer.
  
  There is a simple client app on every DeltaV node called Watchit. This connects directly to the DeltaV communication layer. It's a good troubleshooting tool. If the value you seek is not seen in Watchit, the problem is not with Excel addin, but if it is visible in Watchit, don't reboot the server for a problen in Excel.
  
  There is also OPCWatchit, which connect at the OPCDA server. It also has a browser.
  
  I also believe you have to load the excel add in on every computer that you expect to have spreadsheets that use it. if you copy a worksheet from one computer to an other, that does not install the addin and the DVREAD and DVWRITE commands would be unrecognized.

  Andre Dicaire

  • Cancel
• timalg

  

  • 17 Aug 2020 8:26 AM

  In reply to Andre Dicaire:

  Thank you for your answer ,
  I used the watchit tool and can see the values on the watchit ,also I opened an excel file which contains delatv.xla and I can read the value of the parameters
  I used OPCwatchit the server is opc.deltav.1 the status is:server is succeeded
  I copied the delatv.xla excel addin from a PC(historian server) to the redundant historian server.so reagrding your answer it is impossible make DVREAD and DVWRITE commands recognized again?

  • Cancel