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

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.

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

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

Featured Post

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

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…

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …

The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels.
Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…