Microsoft Office Forums Use VBA to import an access table

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2019, 02:57 PM
Thompyt Thompyt is offline Use VBA to import an access table Windows 8 Use VBA to import an access table Office 2010 64bit
Novice
Use VBA to import an access table
 
Join Date: Mar 2015
Location: El Paso, TX
Posts: 8
Thompyt is on a distinguished road
Default Use VBA to import an access table

I have looked on the Access forums to export a table to VISIO without success. SO I am trying here to see if there is a way to import/link to an access table using VISIO VBA. I have written code in access to filter a table, and Open Visio, and close Access already.



Any suggestions?
Reply With Quote
  #2  
Old 04-25-2019, 04:13 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: 1,361
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

Which version of Visio are you using. Visio Professional supports tables of data. But both Professional and Standard versions allow VBA to access data to automate drawings from other applications.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 05-03-2019, 04:02 PM
Thompyt Thompyt is offline Use VBA to import an access table Windows 8 Use VBA to import an access table Office 2010 64bit
Novice
Use VBA to import an access table
 
Join Date: Mar 2015
Location: El Paso, TX
Posts: 8
Thompyt is on a distinguished road
Default

I would look to use the standard if possible since a lot of computers have standard and not Pro. Thus I am looking for VBA specific.
Reply With Quote
  #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: 1,361
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
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
  #5  
Old 05-07-2019, 09:42 AM
Thompyt Thompyt is offline Use VBA to import an access table Windows 8 Use VBA to import an access table Office 2010 64bit
Novice
Use VBA to import an access table
 
Join Date: Mar 2015
Location: El Paso, TX
Posts: 8
Thompyt is on a distinguished road
Default

I have no code as of yet. I am trying to figure it out. I know that you can have VISIO import a table data. Same effect as a spreadsheet. I'll delve into the link you provided as a start.
Reply With Quote
  #6  
Old 05-07-2019, 11:24 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: 1,361
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

With Visio Professional, you can import a table into 'metadata' that sits in an Excel-like table in the file.

With both Visio Professional and Standard you can use VBA to make available that tabular data but you don't have a single metadata object to 'store' the tabular data and would therefore make use the data while the macro is running to build a graphic using particular master shapes according to the rules you specify in the code.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 06:08 AM.


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