From a spreadsheet the syntax for addressing the RTD Server is:
If you want to create a VBA wrapper around this then the code can look like:
Wrapper = Application.WorksheetFunction.RTD("alignmentsystems.node2rtd2", "my_computer_name", "510")
Replace my_computer_name with the name of your PC where the RTD Server is running locally.
If you don't include my_computer_name in your code then the VBA wrapper will not work.
If you want to replicate this, download the Excel Worksheet code from github. You can also download the C# code to create the Excel RTD Server from github
For further reading, see:
Excel RTD Server implementation in C#......Part 1
Excel RTD Server implementation in C#......Part 2
Excel industrialisation...Part Eight "Enumerating RTD Servers"