• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Visio Guy

Smart graphics for visual people

  • Hire Me
    • Hire Me
    • Résumé
  • Products
    • Products
    • Bubble Revision Shape
    • Layers to Pages Utility
    • Rack Unit Dimension Line
    • Radial Elements Tool with up to 100 Wedges
    • Text on a Circle Visio SmartShape
  • Index
    • Articles by Date
    • YouTube – VisioGuy
    • Download Information
    • Suggestion Box
    • Shop
    • Visio Art
    • Visio Links
    • – Visio Shapes & Stencils
    • – Visio Templates & Drawings
  • About
    • About
    • Donate
    • GitHub
    • jsFiddle
    • Reading List
    • Subscribe & Follow
      • – E-mail
      • – facebook
      • – Twitter
      • – RSS
    • Privacy Policy
  • Discussion Forum
    • Visguy Discussion Forum Links
You are here: Home / Archives for Excel

Excel

Dynamic Updating Org Charts in Visio!

March 23, 2020 By Visio Guy Leave a Comment

I just found a great video that showcases a new feature where Visio organization charts are automatically built and updated within Excel, using Excel data! [Read more…] about Dynamic Updating Org Charts in Visio!

Filed Under: Power User, Video, Visio 2016 Tagged With: Data Visualizer, Excel, Office 365, SharePoint, Visio Online

Sales Force Automation With Visio

June 3, 2007 By Visio Guy 20 Comments


One of the areas in which Visio particularly shines is that of Sales Force Automation. With Visio, a rep can sit on-site with a customer, and visually spec out a system or an installation. The components in the Visio schematic can be linked to real product-data, and can be analyzed via code to generate bills-of-material and reports automatically.

On MSDN, I recently uncovered “oldie but goody” demo that shows off these capabilities. I created it for Visio 5.0, while I still worked for Visio Corp, and it still works with Visio 2003! The demo illustrates how a fictitious candy-manufacturing line might be laid out. Custom shapes represent general classes of equipment, and database links behind the shapes specify real-world items. With the click of a button, a Bill of Materials, is generated in an embedded Excel spreadsheet, sitting right on the page!

[Read more…] about Sales Force Automation With Visio

Filed Under: Code, Shapes Tagged With: BOM, Code, Database, Excel, Integration, Programming, Sales Force Automation

Primary Sidebar

Get Visio Guy Stuff

Visio Guy Products↻
Visio Guy product image

Post Categories

Buy my book!

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tag Cloud

A/V Artistic Effects BPM Code Connectors Control Handles Countries Custom Patterns Custom Properties Data Graphics Data Linking Data Visualization David Edson David Parker Fill Format Formulas Functions Geometry Gradient Images Links Maps Multi-shapes Network Programming repeating shapes Resources Right-Click Actions Scale Shape Data ShapeSheet ShapeSheet Formulas ShapeSheet Functions SharePoint shiny SmartShapes Sport Sports Text Themes Tools Transparency User-defined Cells Visio 2007 Visio SmartShapes

Top Posts & Pages

  • Crayon Visio Network Shapes, Revisited
  • Visio 2016 Training Videos
  • Go 3D with Free Isometric Piping Shapes for Visio
  • Map of World
  • - Visio Shapes & Stencils
  • Sankey Diagram Shapes for Visio
  • Crayon Network Shapes
  • Visio Wood Grain Fill Pattern
  • Visio Radial Grid
  • Visio Radial Grid v3

www.visguy.com - Visio Guy - since 2006

 

Loading Comments...