Hi Mike,
this problem reminds me very much of
this one.
It works with Visio 2007 and newer versions.
As preparation, set up a shape that has it's pinx and piny depending on custom properties...
Then linking to data: Menu Data / Link Data to Shapes / ... select your excel file ... either selected individually shapes or drop your new one from a stencil.
Cheers
Yacine
---- a second, more attentive reading:
you should not need any VBA, unless you really want it.