Search found 3 matches

by JonBear
Fri Mar 09, 2018 11:33 am
Forum: VB and VBA (Excel, Access)
Topic: VBA to Read data from Picolog PLW file
Replies: 5
Views: 5621

Re: VBA to Read data from Picolog PLW file

I have continued to look into the issue of reading the Start Time from the ‘PLW’ file and I think I have found a solution. I will detail what I have done for interest if any other users have a similar problem. For a ‘PLW’ time of 05-02-18 the 32-bit value at bytes 568-589 = 736,730. You stated that ...
by JonBear
Thu Feb 08, 2018 10:55 am
Forum: VB and VBA (Excel, Access)
Topic: VBA to Read data from Picolog PLW file
Replies: 5
Views: 5621

Re: VBA to Read data from Picolog PLW file

Hi Hitesh, Thank you for replying. I have looked again at the 'PLW Recorder' and see that 'PLW' is the only output format. There is a 'CSV' option on the Player, but I was hoping for my routine to not require any manual input. I wanted Excel to open the 'PLW' file, get the temperature values and TC-...
by JonBear
Wed Feb 07, 2018 12:14 pm
Forum: VB and VBA (Excel, Access)
Topic: VBA to Read data from Picolog PLW file
Replies: 5
Views: 5621

VBA to Read data from Picolog PLW file

Hi All, I am being supplied with temperature data from a TC-08 and can load this into the "Picolog Player" and view the readings with no problem. As I am going to be passed a PLW file daily I wanted to develop a more automatic method of extracting the data directly - eventually to import into a SQL ...