AnsweredAssumed Answered

VBA for Pushing old Excel data to Pi

Question asked by TuckerW on Nov 21, 2017
Latest reply on Nov 22, 2017 by pmackow

Hello

I recently changed operator lab data from an Excel sheet to a Manual entry sheet that pushes data to Pi using the VBA code in PIEXAM32 that is included with DataLink. The old data, about 3 years worth, is simply left in the Excel sheet and I'm wanting to backfill the old data onto the Pi server so that all data is now located there and can me used with operational data. I know a little about VBA but like the PIEXAM32 includes the code for data in that format, is there a VBA for pushing a large about of data in the array format I have? The format of the data is pictured below.  I can manipulate another VBA if it is in the general format.

 

Thanks

TuckerW

Outcomes