Improve company productivity with a Business Account.Sign Up

x

Microsoft Visio

Visio is a diagramming and vector graphics application that is part of the Microsoft Office family that allows the user to create diagrams for organizational and planning purposes. The Premium edition has additional templates for more advanced diagrams and layouts, as well as capabilities intended to make it easy for users to connect their diagrams to data sources and to display their data graphically, as well as intelligent rules, validation, subprocess (diagram breakdown). one-step connectivity with Excel data, information rights management (IRM) protection for Visio files, modernized shapes for office layout, detailed shapes for site and floor plans, modern shapes for home plans, and IEEE compliant shapes for electrical diagrams.

Share tech news, updates, or what's on your mind.

Sign up to Post

I know very little about vba. But am trying to tweak a macro for visio.

I want to tweak text but can't find anything on this:
 
            ' set font size and color, text alignment, border, fill and shadow
            .Cells("Char.Size").Formula = "10 pt"
            .Cells("Char.Color").Formula = 0     ' black
            .Cells("Para.HorzAlign") = 0         ' left justify
            .Cells("LinePattern").Formula = 0    ' none
            .Cells("FillPattern").Formula = 0    ' none
            .Cells("ShdwPattern").Formula = 0    ' none

1) Is there a table  that lists what numbers to use to change HorizAlign to get centered?

2) What if I wanted to bold the text?

3) there's a line after these for text (it's a table of contents):   .Text = arrPages(i, 1) & vbTab & CInt(arrPages(i, 2))

I'd love for the space between the page name and page number to be dotted  like:   Licenses.. . . . . . . .3

Do you know how I could get that?

Any idea why I can't find much about this on the web? I was googling cells syntax vba and pasting these lines into google. Didn't come up with anything.

Thanks!
0
Free Tool: ZipGrep
LVL 12
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Hello, I would like to use Visio as a "sales automation tool". I will be reviewing floor plans with customers and want to create an interactive experience. The plans (which I already have) contain plotted assets that are currently stagnant and not connected to any data source... I would need each asset to have data linked to it, I assume via the serial number of the asset/SmartShapes. The cost of each item in the drawing would be retrieved from either Excel or an Access database and the TOTAL COST OF OWNERSHIP would appear on the drawing page in a table summed up.. As I "uncheck" assets, the total cost of ownership would update accordingly, providing the customer with updated costs should they remove specific devices.. The data part I can customize and insert..

...but... would anyone be interested in helping me with a high-level overview of what else I need to do? I have limited experience with Visio but am able to pick up any software rather quickly. Would this require more than Visio/Excel?
0
Thanks to someone here and finding another script on the web, I realize I'd like parts from both of these scripts.  

The script that Scott wrote / posted in:

https://www.experts-exchange.com/questions/29090658/Is-there-a-way-to-make-a-dynamic-table-of-contents-page-in-Visio.html#a42510143

sorts alphabetically, which I realized, I really need.  But puts each entry in separate text boxes.

The script I found in:

http://www.stephen.turbek.com/articles/2007/04/automatically-create-table-of-contents.html

Sorts by page number and puts all the text in a single text box / easier for me to format text, etc.
Sub table_of_contents_creator()
'this macro creates a table of contents in a visio document by
'going through the pages in the document and adds the page number and page title

'by stephen turbek s@stephenturbek.com
'written for use in microsoft visio 2003 SP1

'adapted from http://www.greenonions.com/tocscript
'I added allowing user to select a text box and replace the contents, rather than build lots of little boxes
'this way you can style the text easily, and simply replace the contents when you update the doc
'note: this is my first VB script

' define a shape to use for the Table of Contents (TOC)
Dim TOCEntry As Visio.Shape

'get selection
Dim selectedShapes As Selection
Set selectedShapes = ActiveWindow.Selection

'is any shape selected to put the ToC in?
If selectedShapes.Count > 0 Then
    'take the selected shape to put the table of contents in
  

Open in new window

0
Hi!
 i'm trying to change between visio pages from code. That means i need to set the VisioApplication.ActivePage, but it is readonly. So i'm trying to set the VisioApplication.ActiveWindow.Page.
All good, but when i try that, i get a runtime exception 'Invalid container identifier.'. Anything i tried didn't work. I know that VisioApplication.ActiveWindow.Page is a dynamic variable in c#. But i still don't know how to handle this exception. My code is :

Globals.ThisAddIn.Application.ActiveWindow.Page = Globals.ThisAddIn.Application.ActiveDocument.Pages[0];

I need to mention that it is a Visio AddIn project.
Please, i'm trying to fix this out for 2 weeks, and nothing worked. Any help will be really apreciated.
Thanks!
Dimitrie
0
When I knew very little about visio, in making network docs, I would jam way too much on 1 drawing, thinking I had to make an entire different file with a 2nd page.  DUH!

So I know a little more and love the seperate pages and being able to have a common background on all of them, etc.

Now, is there a way to make a table of contents page? A first page that lists the name of each page in the file?  Maybe updates automatically?  When you add another page / rearrange the order of pages, this page auto updates?
0
Looking for a High Res Visio 2016 Stencil for a EMC (Dell) Data Domain 6300

The stencil needs to have the following Characteristics
  • High Resolution Image able to zoom in and do wire layouts
  • DD-6300 Data Domain Stencil (Front and Rear)
  • Contain DS-60 Shelf (Front and Rear)
  • Contain ES-30 Shelf (Front and Rear)


Please provide a File Location or URL to the exact download location.

Thanks in advance for your assistance with this.
0
Hi I have to do system architecture diagrams for environment

Its very documentation heavy, have to cover VMware, Active Directory, 2008R2 forest mode and on premise Exchange 2010

Is there any guidelines people would recommend i realise its a general query

For instance are there free tools that provide mapping which i can use with visio

I have seen the free stencils Veeam provide and they look good

I am looking to do high level overview then go a bit deeper and also include support documentation which will be a lot more straightforward

Any pointers appreciated
0
I feel completely stupid asking this, but I've been struggling for an hour and I just can't seem to figure it out. I've searched the web and found several pages on how to MAKE custom lines in Microsoft Visio, and I have been able to do that. However, I cannot seem to manage to figure out how to actually insert the custom line onto my document. Help?
0
Hello,

I am working with Visio and creating Process Flow Diagrams, not a problem there.

When the Process Diagrams are complete, I capture the full Process Flow as an image using the "Snipping Tool" and place the image(s) in a document.

Some of the text within the various process boxes is a little grainy and this is the issue I am trying to resolve.

Is there a way I can get a sharper and crisper image of these Process Flows between capturing them in Visio and placing them as images within a Word Document?
0
In Visio, org charts, can all pages be formatted at once ? Struggling to put a head and a backround on each page without having to do it manually. Is there a Visio manual at all?
0
Free Tool: Subnet Calculator
LVL 12
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

In Visio, wizard org  chart, how to I keep a currency format when uploading from excel ??
0
Recently upgraded to Visio 2013 where there are now photo placeholders when using the org chart wizard. This was not the case with Visio 2010. How do I get rid of the placeholders which I don't have room for with a 475+ assoc org chart. I want the simple no frills/text only version and I would like to alphabetize the document. Any tips for quickly learning the new version would also be helpful.
0
I'm using Visio 2013 to do a floorplan.  But the default interior wall thickness is 4".  I need it to be either 3-1/2" or 4-1/2".  

How do I change the wall thickness?
0
Hello,
I have an Auto-CAD .dwg that I would like to edit in Visio 2016.  I can convert it but the only thing I can do is move the entire layer with walls and tanks instead of individual shapes.  I've checked witht he person who created this and they assured me the .dwg is not locked and is editable.  Ultimately I would like to be able to move around the shapes to see if there is a better configuration.

Any help would be appreciated.
Thanks!
0
Hi There is a picture in Visio2013. Is it possible for us to change the picture into transparent one? It means removing any background color etc and characters of the picture are left? Thank you
0
What is the best software for auto-generating nice network diagrams
with least effort for busy network engineer? I really like Netbrain but
I couldn't afford that as an individual (used it at a large company).
Plus I don't need the monitoring and troubleshooting parts of
netbrain. I just need excellent discovery and map drawing. Any
recommendations?
0
Hey guys, Im on a new project in my company and I need to make some things in Visio 2016.

I want to write a vba code that create a property in shape data and then fill it with the container's shape name. Is there possible?

Ive already wrote a code that creat a property "Setor" in all shapes on the page, but I need to fill this property with the name of a container the shapes are into.

The code that Im using is this:

Private Sub Setorizacao()

Dim visShape As Visio.shape
Dim visPage  As Visio.Page



Set visPage = ActivePage

For Each visShape In ActivePage.Shapes
   
   If visShape.CellExists("LockWidth", False) Then
   
   Call InitSetor(visShape)
   
   End If
   
   Next
   
   
           
End Sub

Sub InitSetor(ByRef shape As Visio.shape)

' Create Prop.Setor if they don't exist; set both fields to null

    If Not shape.CellExistsU("Prop.Setor", False) Then
        shape.AddNamedRow visSectionProp, "Setor", visTagDefault
    End If
    shape.CellsU("Prop.Setor").FormulaU = ""
    shape.CellsU("Prop.Setor.Label").FormulaU = Chr(34) & "Setor" & Chr(34)
   
   
End Sub



Thank you in advance.
0
My client is getting An error (1416) occured during the action Save- Visio 2010. All the fixes on google do not work. She is not inserting PDF's but she is inserting pictures.
0
visio how to see shapes stencils then task, artifact, start msg event, gateway, intermediate event.

how to select above kind of shapes and draw nice diagrams to demonstrate systems

for me all disabled some reason.

please advise
visio.png
0
Free Tool: Path Explorer
LVL 12
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

My company uses Onedrive for Business along with Visio Pro.

I am unable to edit master shapes in any of our stencils, the option is greyed out (see attached image).

No one else has any stencils open and I have made sure to close all stencils before attempting.

The only way at the moment I am able to edit shapes is to copy the folder to my desktop and then copy it back to OneDrive.

We would like a solution which allows anyone to edit or add shapes to stencils.

Thank you for your help.
edit-stencil-grey-out.png
0
I want to change the order of my Organizational Chart Data from:

Title
Employee ID
Title Box: Employee Name

I want to have the employee position title show in the Title Bar where currently the Employee Name is Showing. I want to do this for all shapes.

I generated an Organizational chart walking through the wizard, however, in the Title Rectangle box the employee name shows, I'd like their position placed there.

Thanks
0
I am looking to get a patch panel diagram together. Dont know the brand of panels but 1 U's 24 ports.  I cant seem to find a good stencil set for Visio that includes both the front ports and the back for the punch downs.

Any recommendations?  tried visiocafe already.
0
hello,
i.ve scom 2016 and need to specify some service that i need to show using the visio to make dashboard. so if i need to check health of the DNS service in my 3 domains how can i do that and shall i choose. also if  i need to check the status of my DHCP subnets can i do that?
i'm using visio 2013 and the scom addin installed but it's for system centre 2012 does it make any effect?
also if i need to just click on the service from the visio should it gives me the status of this object only?
thanks
0
How can I export the users which have Visio Pro Plus in O365
0
Hi ,

We migraded our KMS volume license server to a new server (2012R2) and 2013 project and 2013 visio are not activating.
Office 2013 and windows are fine , visio 2016 and project 2016 are also activated straight after a new install.
The only differents i see is that the office 2016 suit is standing in active directory based activation part of the volume licence managment tool.

Office 2013 and visio 2013 and project 2013 have the same key.
Any idea's?
thanks
1

Microsoft Visio

Visio is a diagramming and vector graphics application that is part of the Microsoft Office family that allows the user to create diagrams for organizational and planning purposes. The Premium edition has additional templates for more advanced diagrams and layouts, as well as capabilities intended to make it easy for users to connect their diagrams to data sources and to display their data graphically, as well as intelligent rules, validation, subprocess (diagram breakdown). one-step connectivity with Excel data, information rights management (IRM) protection for Visio files, modernized shapes for office layout, detailed shapes for site and floor plans, modern shapes for home plans, and IEEE compliant shapes for electrical diagrams.

Top Experts In
Microsoft Visio
<
Monthly
>