Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-05-2019, 03:58 PM
Guessed's Avatar
Guessed Guessed is offline Use VBA to import an access table Windows 10 Use VBA to import an access table Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Access denied while trying to import from .pst ctharp Outlook 0 03-08-2016 09:24 AM
Use VBA to import an access table Import autotext from a table? eiol Word 5 01-07-2016 05:34 AM
Import from .CUB files in MS Access vamsikrishnad Office 0 12-30-2014 03:19 AM
Use VBA to import an access table Import data from CSV to table gebobs Excel Programming 4 10-20-2014 04:40 PM
Use VBA to import an access table MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft