• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

moving excel graphs and data to Powerpoint

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
montrof
Asked:
montrof
  • 8
  • 5
1 Solution
 
nutschCommented:
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
 
montrofAuthor Commented:
This is perfect Thanks
0
 
montrofAuthor Commented:
I do seem to get an error when i runt he macro . it says -2147188160 Method "Item' of object 'Slides' failed: Slide3
0
Technology Partners: 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!

 
montrofAuthor Commented:
Also How do I figure out the size and position in ppt so I can replicate that?
0
 
nutschCommented:
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
 
nutschCommented:
are you getting the error on the first transfer? What line of the macro?

T
0
 
montrofAuthor Commented:
Yes I get an error just about every time, It still seems to run.
0
 
nutschCommented:
Still does the job?
What line does the error comes at (if you click debug)
0
 
montrofAuthor Commented:
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
 
montrofAuthor Commented:
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
 
nutschCommented:
in the immediate window (Ctrl+G in the visual basic editor)
0
 
montrofAuthor Commented:
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
 
montrofAuthor Commented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 8
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now