Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2014, 10:17 PM
san1979 san1979 is offline Create Visio Diagram from Excel Windows 7 64bit Create Visio Diagram from Excel Office 2007
Novice
Create Visio Diagram from Excel
 
Join Date: May 2014
Posts: 2
san1979 is on a distinguished road
Default Create Visio Diagram from Excel

Hi,

I need to write a code to create visio flow diagram with excel inputs(Excel 2007). Attached is the requirement.


Please help.
Attached Files
File Type: docx Requirement_Specification.docx (83.0 KB, 13 views)
Reply With Quote
  #2  
Old 05-09-2014, 03:24 PM
BobBridges's Avatar
BobBridges BobBridges is offline Create Visio Diagram from Excel Windows 7 64bit Create Visio Diagram from Excel Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

If you're going to create a Visio document, san, you need to use the Visio object model. You can certainly do it in Excel; but you'll be referring to the Visio application and its objects from within your Excel program. Alternatively you can run the VBA program in Visio and from there refer to the Excel application and its objects. Actually that's probably how I'd do it—either that, or do it in VBScript and refer to both objects from one doubleclickable icon.

But none of this can happen without using the Visio object, however that looks. Is Visio part of MS Office, now? If so, I'm sure this can be done.
Reply With Quote
  #3  
Old 05-09-2014, 06:37 PM
macropod's Avatar
macropod macropod is offline Create Visio Diagram from Excel Windows 7 32bit Create Visio Diagram from Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by BobBridges View Post
Is Visio part of MS Office, now?
It never has been - it's a separate product that can integrate with Office.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-09-2014, 07:08 PM
BobBridges's Avatar
BobBridges BobBridges is offline Create Visio Diagram from Excel Windows 7 64bit Create Visio Diagram from Excel Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Cool! How does the integration work? Is there a VBA-accessible object, or what?
Reply With Quote
  #5  
Old 05-09-2014, 07:13 PM
macropod's Avatar
macropod macropod is offline Create Visio Diagram from Excel Windows 7 32bit Create Visio Diagram from Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, Visio has a VBA object model. Office apps aren't the only ones to do so. Even completely independent products like Adobe Acrobat (Pro) have them and can both automate and be automated from Office or other VBA-enable apps.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Visio Diagram from Excel Create Visio Diagram from Excel san1979 Visio 2 06-18-2014 05:44 AM
Create Visio Diagram from Excel Inputing Text from Excel sheet to multiple Word documents and Visio File Jazz43 Office 1 05-30-2013 02:08 PM
Create Visio Diagram from Excel Create DDL from Excel source BradleyS Word 1 01-30-2013 10:58 PM
Create Visio Diagram from Excel How can I create hidden cell in Excel? itsolexpert Excel 2 05-15-2012 09:59 AM
How Do I Create Excel Web Pages With Java highbids Office 0 04-13-2006 06:53 PM

Other Forums: Access Forums

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


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