Solved

Visio - I need the field name for sheet - the USER ASSIGNED NAME.

Posted on 2013-11-22
2
429 Views
Last Modified: 2013-11-25
I would like to have the name of the sheet appear in a text box on my diagram.

I used the name() function but it returned SHEET.45.  What I wanted was the name I assigned to the sheet (Omaha Network).

I already am using FILENAME() and DIRECTORY().
0
Comment
Question by:brothertruffle880
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Expert Comment

by:Visio_Guy
ID: 39671294
Hi BT,

If the shape has a non-generic name, then NAME() will return something non-sheet-like, e.g.: PC.48, as you've already seen.

You can then use the ID() function to get the numeric part, ie: the 48 in this example. Since "Sheet" is a given, there is no ShapeSheet function that returns the whole "Sheet.48". But you can concatenate:

= "Sheet." & ID()
0
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 39671452
If the sheet you're referring to is the page itself and the name you want is the name on the page tab, then I think the function you're looking for is PAGENAME().
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

PaperPort (http://www.nuance.com/for-individuals/by-product/paperport/index.htm) is among the most important applications that I run on my Windows computers. I use it every day, for nearly all of my document and photo scanning, as well as most of my…
In a previous article here at Experts Exchange (http://www.experts-exchange.com/articles/18414/Create-a-PDF-file-with-Contact-Sheets-montage-of-thumbnails-for-all-JPG-files-in-a-folder-and-each-of-its-subfolders-using-an-automated-batch-method.html)…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
It’s easy to embed any of your public Prezi presentations on your website or social network to share with others. Learn how simple it is in this tutorial.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question