Solved

moving excel graphs and data to Powerpoint

Posted on 2011-09-09
13
434 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
  • 8
  • 5
13 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 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
 
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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
Setting the Scene PowerPoint is a creative tool in the right hands but it also includes a much underutilised programming dimension. In this beginner level article, we're going to show you some of some key elements of programming PowerPoint using th…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

707 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