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

• Pierre

  

  • 3 Jun 2020 10:29 PM

  Hi Stuart,
  I was wondering if you ever found a solution to this problem and if you could share the solution. I am having a similar problem but I can't even get to the Deltav Excel Add-in VBA code and modify it. Would you mind sharing the folder where that code is saved in the file system? Thank you,

  • Cancel
• Lun.Raznik

  

  • 5 Jun 2020 3:13 PM

  In reply to Pierre:

  I tried to poke around this last night, it does not seem like it is possible with this latest version of DeltaV Excel Add-in.
  
  Of course you can "hack" it but not in the usual do it from VBA code.

  • Cancel
• timalg

  

  • 13 Aug 2020 4:06 PM

  In reply to Lun.Raznik:

  Hi ,
  
  I use an excel worksheet which uses deltav.xla excel add in as an external link when I try to open the worksheet a message apprear the workbook contains one or more links that can not be updated.the I choose edit and I get deltav.xla status:error:undefined or rectangular cell .I click the update then I got the message can not update deltav.xla does not find the function DVREAD.please how can I resolve this problem.can you please help me
  
  regards

  • Cancel
• Lun.Raznik

  

  • 13 Aug 2020 4:14 PM

  In reply to timalg:

  Can you post screenshot? And what version of DeltaV?

  • Cancel
• timalg

  

  • 13 Aug 2020 4:35 PM

  In reply to Lun.Raznik:

  Hi Lun,
  The version is 7.4.2

  • Cancel
• timalg

  

  • 13 Aug 2020 4:35 PM

  In reply to Lun.Raznik:

  the version is delta v 7.42

  • Cancel
• timalg

  

  • 13 Aug 2020 4:44 PM

  In reply to Lun.Raznik:

  sorry I am new in this forum i did not find where to add screenshot,when i open the file I get this message: then I open edit link i get source:deltav.xla type worksheet update :A status error undefined or non rectnagular name,the when I click update values i Get message:microsoft office excel cannot find DVREAD on deltav.xla there are two possible reasons: .the name you specified may not be defined
  .the name you specified is defined as something other than a rectangular cell reference check the name and try again

  • Cancel
• timalg

  

  • 13 Aug 2020 4:54 PM

  In reply to Lun.Raznik:

  The first message is:this workbook contains one or more links that cannot be updated.
  To change the source of links ,or attempt to update values again, click edit links
  To open the workbook as is,click continue

  • Cancel
• timalg

  

  • 13 Aug 2020 5:26 PM

  In reply to Pierre:

  can you help me please

  • Cancel
• Lun.Raznik

  

  • 13 Aug 2020 5:55 PM

  In reply to timalg:

  This is pretty old system!

  For posting with image, click on "Use rich formatting". Once in the new editor, do Insert | Insert Image/Video/File. 

  Can you please check if you have macro disabled? Also, are you running Excel on DeltaV station? 

  By the way, what verion of Excel are you using? 

  • Cancel
• timalg

  

  • 13 Aug 2020 9:35 PM

  In reply to Lun.Raznik:

  Hi lun,
  The macro seems to be enabled I checked in the security level of macro I found the case low(not recommended checked).
  Also we use excel 2003.we are running in a delta v station where delta v continuous historian is installed.

  • Cancel
• timalg

  

  • 14 Aug 2020 6:43 AM

  In reply to Lun.Raznik:

  to be able to solve the problem I would like to know in general what is the configuration carried out by emerson for the process of transferring data from the delta v to the file excel report, I know that in our case we have: the excel add in deltav.xla, and that in the excel report file there is the DVREAD function and other excel add in functions and there is also the DVCHvalue function.
  how the data ofdelta v the continuous historian are transferred; I cannot find the databases used
  what is also the role of the Delta V excel server?

  • Cancel
• LaurentB

  

  • 14 Aug 2020 7:24 AM

  In reply to timalg:

  Hi all

  In old DeltaV Versions it was almost easy to "ack" the deltav Write functions in deltav.XLA ( and it works fine if you select all cells of the sheet including the time interval cell)

  As it was a big safety hole ( wrong data can be written by inadvertance by any excel sheet , and create unmanaged command on process) Emerson decide to reenforced the security of addin to avoid automatic write functions.

  In most of the case to build a report you don't need to write into DeltaV.

  On new version of DeltaV ( from version 12 if I remember) there a very usefull tools called Excel reporter, which allow to get data from historian, with a wizzard to create scheduled tasks for automatic report. ( you can also create a button on HMI to run the report on demand)

  Depending of the version, DeltaV excel reporter is located directly on DeltaV Bon folder or on deltaV DVD ( disk 1 if I remember well)

  • Cancel
• timalg

  

  • 14 Aug 2020 7:37 AM

  In reply to LaurentB:

  Hi laurent,
  
  
  
  please can you detail about this:
  In old DeltaV Versions it was almost easy to "ack" the deltav Write functions in deltav.XLA ( and it works fine if you select all cells of the sheet including the time interval cell)
  
  please what do you suggest me to resolve the problem(what steps i have to follow)
  also how delta v continuous historian send data to the excel file

  • Cancel
• LaurentB

  

  • 14 Aug 2020 7:56 AM

  In reply to timalg:

  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

  • Cancel