Using Transfer-XL-To-PPT Macro and needs some changes

Hi guys,

Some one was nice enough to provide me with the Transfer-XL-To-PPT Macro but I need to make some changes and it also seems to give weird error messages.  So what i need is to be able to put the position in ppt where the graph will go and also the height and width of the graph.  I have a current presentation so I need to know how to tell what the graphs are already set at so I can match that. I appreciate any help that you can provide.  I am attaching the macro.

==========
Prior related question: http:/Q_27300337.html
Transfer-XL-to-PPT.xls
LVL 1
montrofAsked:
Who is Participating?
 
JSRWilsonCommented:
The Top Left Height and Width of a shape are measured in POINTS
72 points = 1 inch

If you need the height and width of the slide

MsgBox ActivePresentation.PageSetUp.SlideWidth
MsgBox ActivePresentation.PageSetUp.SlideHeight

Both in Points
0
 
montrofAuthor Commented:
I need the information like width height position of the images or shapes on each slide.
0
 
montrofAuthor Commented:
the calculation is all i needed thanks so much
0
 
montrofAuthor Commented:
So i was wondering if you could help with an issue when ever the sizes are inserted the Height is being set and then the width is being scaled because the lock aspect ratio is checked.  I tried to edit the function Function CopyRangeToPPT so that lockaspectratio = msofalse but this does not seem to be working.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.