I'm trying to get real time data from my data-logger in a column using macros. I'm stuck.

[adhitiraman]

I'm very new to macros so I don't understand much.

I'm trying to get the serial input from a TC08 Thermocouple datalogger to show up in a single column in Excel. The example code they have given with the SDK is below. I'm not able to upload the .dll file.

The program only updates the values in three cells. 4A, 4B, and 4C every second, but this isn't what I want. I want it to upload the new reading in the next row every second. I'm very confused as to how I can do this.

Any help will be welcome.

Regards

[AranDG]

This is not going to work with the current sheet setup as you have data in cells below the output range, but if you used K, L & M for example:

Change the Timer1_Timer subroutine to:

Please Login or Register  to view this content.

[adhitiraman]

Thanks for your quick response. The code gave me a Runtime Error '1004' Application-defined or object-defined error for this line varRow = ThisWorkbook.Sheets("Sheet1").Range("K1000000").End(xlUp).offset(1, 0).Row

[adhitiraman]

Also, I tried simply incrementing it like this

Please Login or Register  to view this content.

It sort-of works, but it overloads my system and the excel files stops responding. I'm not sure why that's happening.

[AranDG]

Sounds like you're using an older version of excel, try changing K1000000 to K65000, may be a row restriction

[adhitiraman]

This worked perfectly! Thank you so much! <3

[AranDG]

No worries, best of luck with the prest of your project

[LJMetzger]

The following should make the code Excel Version Independent:

Please Login or Register  to view this content.

Lewis

[adhitiraman]

When I change K, L, M back to A, B, C it stops updating column wise and starts updating cell in the same cell again. Why is this happening?

[AranDG]

If you've changed your code, would be good to see the modified version before we could help

[adhitiraman]

No, I haven't. It's exactly what you asked me to change

[AranDG]

If you are still using this:

Please Login or Register  to view this content.

And you've only changed these:

Please Login or Register  to view this content.

Then you needc to change this:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

But as I stated, you already had data in column A so this will mess up your data, unless you've already moved it.