Solved

Visio and powerpoint

Posted on 2010-08-18
11
878 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
  • 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
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 I’ll describe a mashup of containers and lists that meet a real-world need. Prior to reading this ar…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now