Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2022, 08:54 AM
Dalski Dalski is offline Paste From Visio To Excel As List/ Table (Not Image) Windows 10 Paste From Visio To Excel As List/ Table (Not Image) Office 2021
Novice
Paste From Visio To Excel As List/ Table (Not Image)
 
Join Date: Dec 2022
Posts: 2
Dalski is on a distinguished road
Default Paste From Visio To Excel As List/ Table (Not Image)

Can one paste a visio shape (table shape of entity relationship diagram) into Excel & have it appear as a table/ list so you can edit the data; rather than appearing as a useless image.
  • Tried running a Shape Report but a very un-detailed summary generated.





Last edited by Dalski; 12-02-2022 at 11:48 AM.
Reply With Quote
  #2  
Old 12-04-2022, 04:39 PM
Guessed's Avatar
Guessed Guessed is online now Paste From Visio To Excel As List/ Table (Not Image) Windows 10 Paste From Visio To Excel As List/ Table (Not Image) Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,307
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

I only have Visio Standard and aren't sure if you are using a feature reserved for Visio Professional. Can you post a doc that shows a sample of the data you want to extract to Excel?

I would assume it is possible to extract tabular data but would need to experiment to work out the method to do so.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 12-18-2022, 09:55 AM
Dalski Dalski is offline Paste From Visio To Excel As List/ Table (Not Image) Windows 10 Paste From Visio To Excel As List/ Table (Not Image) Office 2021
Novice
Paste From Visio To Excel As List/ Table (Not Image)
 
Join Date: Dec 2022
Posts: 2
Dalski is on a distinguished road
Default

Thanks Guessed, apologies late response.
  • Pic attached
  • Version 2211 Build 15831.20208 (Visio 21)
  • It is a UML Class Diagram With Associations; but I could use an Entity Relationship Diagram in Crows Feet notation if need be.
Attached Images
File Type: png Screenshot_2.png (4.4 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
@Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug ggll Word 0 09-18-2021 11:48 PM
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet CaptainRetired Excel Programming 18 01-04-2018 07:22 PM
Help converting an image to visio dsravan Visio 1 02-19-2016 10:22 AM
font of excel table gets messed up in visio 2013 Strumpfhose Visio 0 10-01-2014 02:40 AM
OneNote - Copy and paste image to the table MartinK OneNote 0 09-03-2013 05:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:34 PM.


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