Macro for Creating a Table of Contents with a Page Number

Started by wfp1, March 09, 2018, 07:40:29 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

wfp1

Hi all,

I was looking for a macro code that would create a table of contents based off of sheet name and would also list the page number for the sheet. If anyone has any suggestions or modifications to one of the many table of contents codes floating around, please let me know.

Thanks!

wapperdude

Do you have any code or macro you're using?  If not, try searching to find something close to what you want.  It's hard to suggest anything without some starting point.  TOCs are e very layout specific.  Your description provides no clue.

Wapperdude
Visio 2019 Pro

wfp1

Quote from: wapperdude on March 12, 2018, 02:53:17 PM
Do you have any code or macro you're using?  If not, try searching to find something close to what you want.  It's hard to suggest anything without some starting point.  TOCs are e very layout specific.  Your description provides no clue.

Wapperdude

The code I was using something like the code here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=505

A code that creates a new page for a Table of Contents then lists each sheet name in a hyperlink form. I would like to add what sheet number the sheet name is found on. So if the sheet was named "Boiler System" and is on sheet 9 out of 30, the table contents will look like:
PAGE NAME               PAGE NUMBER
Boiler System                     9

I hope this helps explain a little better, thanks.

wapperdude

Did a forum search for Table of Contents.  There are many results.  Have you tried doing this?

This looks like a good starting candidate:  http://visguy.com/vgforum/index.php?topic=8298.msg35873#msg35873

Wapperdude
Visio 2019 Pro