Solved

Visio and powerpoint

Posted on 2010-08-18
11
895 Views
Last Modified: 2012-05-10
Hi,

I have 150 diagrams in visio in different taps. How I can put this diagrams in a PowerPoint presentation with visual basic for applications
0
Comment
Question by:joyacv2
[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
  • 8
  • 3
11 Comments
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 33474077
It's certainly possible to automate the work of putting your Visio drawings into PowerPoint but I have a couple of questions first:
  1. If your goal is just to view the Visio drawings in a "slide show" format, have you tried just using Visio in full screen mode? With the drawing file open, press F5 to go into full screen view. You can use the arrow keys or PageUp/PageDown to move back and forth through the files. It's very much like viewing PPT slides.
  2. If your goal is to create a PPT file because you also have other information you want to add to the PPT slides, do you just want images of each Visio drawing in the PPT file or do you want to be able to edit the drawings from within PPT?
  3. If you just want images, I can help create code to do that (not too difficult).
  4. If you want to edit from within PPT, I suggest reading this article to decide about linking vs. embedding:
Let me know what you're trying to accomplish and we'll take it from there.

Regards,
Scott
 
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 33474759
BTW, what versions of Visio and PowerPoint are you using?
0
 
LVL 1

Author Comment

by:joyacv2
ID: 33477009
Hi,

I only need to copy the diagrams from visio to the slides in powerpoint using code. Are 150 diagrams in the visio file in different tabs to the PowerPoint presentation in different slides
0
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.

 
LVL 30

Expert Comment

by:Scott Helmers
ID: 33477268
So you just need images of each diagram on a PPT slide.

Which version of Visio and PPT do you have?
0
 
LVL 1

Author Comment

by:joyacv2
ID: 33487980
Yes, are 150 diagrams in the visio file in different tabs, so I need 150 ppt slides in the presentation
0
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 33489972
I love it when coincidences like this happen...

I was rummaging through the code samples in the Visio 2007 SDK earlier today, looking for sample code to automate creation of Visio timelines. While there, I stumbled across a code sample I'd long forgotten that makes a PowerPoint slide from a Visio drawing page!

So I adapted the code to create a slide for every page in a drawing and the result is attached below. Feel free to adapt it as you wish, or if you need assistance modifying it, let me know.

Two important notes:
  1. The code is written to run against the "active" document. You can paste the code into your Visio drawing, or you can just open this file, then open your drawing, then run the macro.
  2. Visio has a peculiar habit (feature?) when creating jpg images -- it ignores blank space on the page and only creates the jpg for the part of the page that contains shapes. Read the somewhat lengthy note in the code for the workaround.

Scott
 

Save-Visio-as-jpg-and-insert-int.vsd
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 33490042
Forgot to mention one thing -- each jpg image is positioned in the upper left corner of the slide. I didn't do any resizing or repositioning in the code. That's certainly possible but I figured I'd send this as it is so you can see whether it does what you want. Also, because the default slide orientation is landscape, this code works best if your Visio drawing pages are also landscape orientation.
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 33491822
Because this question has come up before, I decided to enhance the code a bit more and write an article about the results -- you'll find a download link to the enhanced version of the code at the end of the article.
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 33530371
Hi -- did you try the code I provided with the article referenced above? I think it should do what you've asked.

Scott
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 33645719
joyacv2 == did the code included with the article referenced above solve your problem? It does save an image of each page of a Visio drawing in a PowerPoint slide. If it solves your problem, please close the question, otherwise, feel free to ask for additional information.

0
 
LVL 1

Author Closing Comment

by:joyacv2
ID: 34654042
Thank You for your help!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Have you ever created a custom Visio stencil – a collection of your own unique master shapes – and then created a drawing by dragging masters onto the drawing page? Have you then made changes to the stencil master and wondered why the shapes on the …
The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine lists. We’ll explore containers and callouts in separate articles. Prior to reading th…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

734 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