the method you are proposing will use DDE which is now pretty much obsolete.
instead ...
if you are looking to access real-time data then you should use OPC (there is an example script in the WinCC manual on how to do this from Excel and can be easily adapted for use in VB)