?
Solved

moving excel graphs and data to Powerpoint

Posted on 2011-09-09
13
Medium Priority
?
443 Views
Last Modified: 2012-05-12
Hi All,

I need some help with moving multiple graphs and data tables from excel to PowerPoint.  I have an excel file that has a couple of charts and tables on each tab that I need to move specific charts to specific slides and location within PowerPoint. (and data tables).  I have to do this every month and it is a lot of work, so I was hoping someone could help me with a macro.  I think the difficult part is the placement of the graphs and data tables within each slide.  

Thanks,
Montrof
0
Comment
Question by:montrof
[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
  • 5
13 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 2000 total points
ID: 36512427
I have this excel file that should be able to help you. I haven't used it in a while but it should be relatively self-explanatory.

T


Transfer-XL-to-PPT---Activity-Re.xls
0
 
LVL 1

Author Closing Comment

by:montrof
ID: 36512431
This is perfect Thanks
0
 
LVL 1

Author Comment

by:montrof
ID: 36512491
I do seem to get an error when i runt he macro . it says -2147188160 Method "Item' of object 'Slides' failed: Slide3
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:montrof
ID: 36512511
Also How do I figure out the size and position in ppt so I can replicate that?
0
 
LVL 39

Expert Comment

by:nutsch
ID: 36512696
to figure out size and position, you can run a macro in powerpoint like this

Sub asdgfasdg()
Dim shp As Shape

For Each shp In ActivePresentation.Slides(1).Shapes
    Debug.Print shp.Left
    Debug.Print shp.Width
Next

End Sub

Open in new window

0
 
LVL 39

Expert Comment

by:nutsch
ID: 36512703
are you getting the error on the first transfer? What line of the macro?

T
0
 
LVL 1

Author Comment

by:montrof
ID: 36512745
Yes I get an error just about every time, It still seems to run.
0
 
LVL 39

Expert Comment

by:nutsch
ID: 36512760
Still does the job?
What line does the error comes at (if you click debug)
0
 
LVL 1

Author Comment

by:montrof
ID: 36512773
Does not give me the option to debug just hit ok.  Also when I run the ppt macro you provided where do I see the results.
0
 
LVL 1

Author Comment

by:montrof
ID: 36512825
Also what about the hieght of the graph because I ran the debug and took the exact values and it does not match what I had before.
0
 
LVL 39

Expert Comment

by:nutsch
ID: 36512831
in the immediate window (Ctrl+G in the visual basic editor)
0
 
LVL 1

Author Comment

by:montrof
ID: 36513271
One more question when I run the code to see the position size and so forth. It just gives me values but I do not know what they relate to or which shape on the slide they pertain to.
0
 
LVL 1

Author Comment

by:montrof
ID: 36528944
IF I wanted to take the macro and control toolbox sheet and insert it into a workbook, how would I change it so you do not need to input the excel path and instead just use the active workbook.
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
A lot of things can happen during a presentation, worst of which is “death by PowerPoint.” Here are a few mistakes to avoid to make your slides clean.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

764 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