Hi, how does the Microsoft Volume License Center work, we purchased some licenses in 2017, do i have to "renew" these ? Products are Office, Visio, etc.

If they expire, can i still use?

Hello expert,

There are many things I love about how Visio helps me
create graphics and UML diagrams quickly.

And there are things that drive me bat stuff crazy:
Heres one going back to 2014
https://www.experts-exchange.com/questions/28308448/Visio-2010-Connector-connects-to-unexpected-shape.html

Another one is that it wants me to use Calibri, which I dislike. Visio will not default
to using the grand master of modern sans serif, Helvetica (or Arial).

Saw an article 'How do I create a new theme in Visio 2013?'
https://answers.microsoft.com/en-us/office/forum/office_2013_release-visio/how-do-i-create-a-new-theme-in-visio-2013/eb896730-509a-4cf6-bf54-c56b99468e27
but  it says to select the Variants option in the Design group. Cannot find
Variants or find anything called Variants using search in Visio.

Found ton of stuff on Visio 2010 and 2016. Only other thing I can find is
https://visualsignals.typepad.co.uk/vislog/2013/10/customizing-themes-in-visio-2013.html
This also refers to Variants.

I can create shapes and text boxes with Arial instead of Calibri  and then be very careful to only
copy existing shapes but this pretty restrictive. And if large sections of a drawing are copied into
a new drawing : Boom everything is Calibri again.

And the default is everything is this sort nasty blue with white color font. UGH!

Anyway to get off Calibri slave trail?

Thanks.

 Allen in Dallas

Hello expert,

Have an Excel spreadsheet on complex project called 'SFTP'.
Excel spreadsheet has a ton of detail on project
but there is so much info that it is hard to see where one
customer is in the SFTP set up process.

So created a Visio that details the process and then
inserted the customers showing where the
customers were in the process, attached.

It would be great if clicking on the Visio customer
node would take the user to the line in Excel
for that customer.

Have tried a couple of online tutorials about how to
link Visio to Excel.
https://classroom.synonym.com/visio-objects-excel-13927.html

But this and others like it explain how to link a Visio
shape to Excel data. All that is required for this project
is to link a Visio shape or text to a row or cell in Excel.

Is this possible?

A link has been created in the past using JavaScript
to create a hot spot on a GIF in an HTML file
that links to another HTML file.

But I was hoping that Microsoft had integrated
there apps enough to go between Visio and Excel

Thanks.

Allen
Payer_TPA_SFTP_process_190701.gif

Does anyone have a strong background on Zetafax?  

We took this client over a while ago and they never paid their Zetafax support so now we're stuck.   Currently our client has 7 lines for in bound and out bound faxes that are handled by a Zeta fax server.   They are currently considering moving to another solution and need us to draw out how the process for Zeta fax works.   I do have access to the Zeta Fax server but I do not know where the fax cards route the lines.  

Basically they are asking us to write out a Visio for them showing them the entire work flow and how that can apply to their new solution they are going with.   Really need help with this one.

I'm looking for a macro to help to me count and display direct and indirect subordinates in Visio Org Charts. I found the sample one online below, but I running into issues with the
"s.Shapes(4).Text = dc" portion.

Function RecursiveCount(s As Shape) As String
    Dim count As Integer
    
    count = 0
    dc = s.FromConnects.count - 1
    
    For i = 1 To s.FromConnects.count
       If s.Text <> s.FromConnects(i).FromSheet.Connects(2).ToSheet.Text Then
            count = count + 1
            rc = RecursiveCount(s.FromConnects(i).FromSheet.Connects(2).ToSheet)
            count = count + rc
       End If
    Next
    If dc > 0 Then
        s.Shapes(4).Text = dc
        If (count > 0) And (count <> dc) Then
            s.Shapes(4).Text = s.Shapes(4).Text & "(" & count & ")"
        End If
    End If
    RecursiveCount = count
End Function
 
Sub CountSubs()
    ' select the top most node then run this macro
    Dim s As Shape
    Set s = ActiveWindow.Selection(1)
    
    ' now recursively update counts
    i = RecursiveCount(s)
    
End Sub
 
Sub SetCountsToBlank()
Dim s As Shape
For Each s In ActivePage.Shapes
        If s.Shapes.count >= 4 Then
            s.Shapes(3).Text = ""
            s.Shapes(4).Text = ""
    
        End If
    Next
End Sub

Select all Open in new window

Greetings:

I'm using Microsoft SQL Server 2017 remotely.

I'm using Microsoft Visio for Office 365 MSO (16.0.11328.20220) 32 bit.

I downloaded and installed the ODBC Driver 17 for SQL server.

Within Visio:

1. I created a new Database Model Diagram from the Software and Database template
2. I clicked on Database -> Reverse Engineer.
3. Under Setup, ODBC Driver 17 for SQL Server is the only driver selected
4. I double click on my data source.
5. I enter the password for the data source.
6. The following error comes up - "The currently selected Visio driver is not compatible with the data source"

Any assistance one might give is most appreciated.

Much thanks,
David Bach

Citrix Cloud, VMWARE Horizon Visio Stencils required.

When I try to download a template in MS Publisher, a list of templates appears under Visio.   When I try to download a template, an error message pops up saying "something went wrong while downloading your template".
Snip.JPG

I have a Visio document that I have added a lot of hyperlinks to that are now incorrect, and I want to delete all of the existing links. I can then reassign them using the hyperlink base

i have one flow diagram in the word document.

how can i copy paste that same diagram in visio and make minor changes to it.

please advise

I had this question after viewing Replacing text in PowerPoint 2016 using VBA.

Is it possible that I can insert a custom textbox in slide theme and it gets updated in actual slides ?
Here what I am trying to do in power point VBA which I have done successfully in Visio VBA.

I want to put the presentation file name on all slides of a presentation.  I have 50+ such presentations containing 25+ slides in each presentation.  The above code requires that I insert a text box on each of the slide manually and then it works if I run the macro.  Any suggestion how to automate the process using Powerpoint VBA ?

I do not want to change the slides theme for each presentation by inserting a text box with file name.  That would defeat the purpose of automation. Visio VBA does it very easily by using code in Auotexec module for each slidepack.

in a microsoft word diagram how to crop similar to how i do in the microsoft paint to erase some text on the present diagram i have

please advise
is there is a way i write new text after erasing old text?
how to do this using visio?

1 A Floor Plan of your assigned secondary school(s) outlining internet coverage (wired and wireless)
Each level should be a different floor plan, (labeled: Ground Floor, First Floor, etc.)
It should highlight all ICT networking devices such as AP, Routers, and Switches etc.
Each room and building should be properly labeled in the floor diagram.
Provide a brief description of the Floor Plan

2. A High Level Network Diagram of your assigned secondary school(s).
Must include all internet service providers
The Diagram must outline the flow from ISP to end user, inclusive of servers and network devices.
Provide a brief description of the Network Diagram

Good day can someone assist me with what I really have to do here ? I never really used visio before .

What exactly are they asking for and how does visio help to show it ?