View Single Post
 
Old 05-05-2019, 03:58 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Post the code you already have and tell us how you want this data to appear in Visio. There isn't a 'table' object in Visio but you can import the data for use in adding, populating and arranging shapes.

An example of how this is done from Excel is https://www.mrexcel.com/forum/excel-...using-vba.html

That example is only populating the text value of each shape dropped on the page. You can also populate other properties of a shape with code along the lines of
aShp.CellsU("Prop.MyPropertyName").FormulaU = Chr(34) & "Hi mum" & Chr(34)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote