Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Visio Training and help » visio courses london - Page duplication

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

visio courses london - Page duplication

Resolved · Low Priority · Version Standard

Reply Thu 17 May 2007, 14:42Delegate Leah said...

Leah has attended:
Excel Intermediate course
Project Intro Intermediate course

Page duplication

Is it possible to duplicate a page in Visio as it is in Excel (insert duplicate page)? Having it as a background page doesn't work because I would need to make slight changes.
Thanks much!

For upcoming training course dates see: Pricing & availability

Reply Thu 24 May 2007, 14:21Trainer Richard said...

RE: Page duplication

Hi Leah

It is not possible to duplicate a page in visio using standard methods.

You can do it via a VBA macro, and I would suggest reviewing the following pages for referece:

http://support.microsoft.com/kb/290581

http://www.welie.com/visio/

They will give you the basic code for duplicating a page using a macro. You will need to copy and paste the information into the VBA editor, and then run the macro.

regards

Richard

Visio articles

· Find Out How Visio 2010 Can Stand The Test Of Translation
· Visio - Pointing Your Business In The Right Direction
· Your Business, Your Demands, Your Visio.
· How To Create Layers In Visio
· Create A Network Diagram In Visio

Visio tip:

Creating an organisation chart in Visio using Excel data

A quick and easy way to create an organisation chart by importing names and titles stored in list format in an Excel spreadsheet into Visio.

1. Select File, New, Organization Chart.

2. Start the Organization Chart Wizard.

3. At the first step of the wizard, select the 'Information that I enter using the wizard' option, and click Next.

4. At the second step of the wizard, select Excel, then type the name of the file.

5. Select Browse to choose the location you wish to save the file to, click Save, and then click Next.

6. Click OK - a Microsoft Office Excel workbook will open with column headings already entered for you.

7. Replace the sample text with the text you wish to appear in your organisation chart. By holding your cursor over each column heading, you should be able to view data entry tips.

8. Save the Excel file, then close Excel.

9. Proceed through the remaining steps in the wizard to create your organization chart from the data you entered into the Excel file.

Visio's organisation chart wizard will also recognise the following file formats (besides .xls):

- Microsoft Exchange Server Directory (Microsoft Exchange e-mail Address Book).

- Tab- or Comma-delimited text (.txt).

- Org Plus (.txt).

- Microsoft Office Access (.mdb) or any other file format for a database created in an Open Database Connectivity (ODBC)-compliant database application.

View all Visio hints and tips