I have written hundreds of Visio VBA macros, many of which incorporate data from Excel, Project and Access. I have also used Visio diagrams to automatically generate Excel workbooks and PowerPoint presentations.
Answers to your specific questions are in the PM area.
BTW, I am one of 14 people in the world awarded by Microsoft as an MVP (Most Valuable Professional) for Visio.