How to make such a macro in Excel?

Question

Visual Basic

Tell me please. I don't know much about Excel macros.
After opening the document, it is necessary to stupidly press the Ctrl + J keys in a cycle every second.
In VB, this is done as SendKeys("^{J}"). Where to enter it and how to do it cyclically - I'll never know.
When this combination is pressed, info from the scales connected via COM is inserted into the excel cell.

Answer 1

as an option here
Or by this request