Powerpoint datasheet for custom graphics

Hi Experts!

I have created a variety of custom graphics. I use them in a Powerpoint macro and size them based on values entered through an inputbox but the problem with this is you have to manually retype or repaste in the numbers into the inputbox every time you run the macro. Is there a way to link an Excel spreadsheet (or a Powerpoint dataset) to these graphics so by changing the numbers in the sheet the graphics would resize?

Ed Matsuoka
Ed MatsuokaPartner/Senior IT SpecialistAsked:
Who is Participating?
 
Jamie GarrochPowerPoint Consultant & DeveloperCommented:
Grrr. I HATE the file management within Experts Exchange. It SUCKS! Whilst they support macro-enabled Excel files, they don't support macro-enabled PowerPoint files and I have been requesting this since last November (they even reported it had been changed in January this year but it hasn't). So, here are the two files again but you'll have the change the extension of the PowerPoint file to .pptm after you download it!!!

Resize-Shapes-using-Excel-data.pptx
Shape-Size-Data.xlsx
0
 
Jamie GarrochPowerPoint Consultant & DeveloperCommented:
Do you just need to store the user's last numbers because you could use the sandboxed registry commands to save and get the stored value:

Dim myValue As Single
myValue = GetSetting("MYAPP", "PREFS", "SCALE", 100)
myValue = InputBox("Enter value", "Scale", myValue)
SaveSetting "MYAPP", "PREFS", "SCALE", myValue
' Do your scaling stuff

Open in new window


If you want to use Excel, that's possible but more involved.
0
 
JSRWilsonCommented:
As Jamie said. If you have a range of options why not have a userform with a dropdown combobox to choose the size needed.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Ed MatsuokaPartner/Senior IT SpecialistAuthor Commented:
Thanks for getting back to me so quickly! I will admit I had never heard of the SaveSetting command and it is nice to learn a new one. I can certainly foresee using it but the reason I'd prefer a datasheet or spreadsheet is that you could then copy that datasheet/spreadsheet and edit it multiple times as well as see the values for checking. Hmm, I guess if I created a userform and populated it with values from SaveSetting that might work but is it impossible or very difficult (which for this old brain is about the same) to just use a datasheet or spreadsheet?
0
 
JSRWilsonCommented:
It is certainly possible to populate a combobox on a userform from a data cheet. You could use a simple textfile, a csv file or an Excel file. This would be a good solution if you edit the values regularly.

Whether you would find it very difficult depends on your skill level of course.
0
 
Ed MatsuokaPartner/Senior IT SpecialistAuthor Commented:
it is frustrating because there is that perfectly useful datasheet sitting behind every Powerpoint chart but I can't use it. I just wondered if that is technically impossible. In my ideal world (which often isn't THE real world) I'd be able to have my graphics be a custom chart where you could double click to open the datasheet, change the cell values and when you exit the graphics have proportionalized.
0
 
Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for Jamie Garroch's comment #a40742518

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
Jamie GarrochPowerPoint Consultant & DeveloperCommented:
I am providing an answer to the original question today.
0
 
Jamie GarrochPowerPoint Consultant & DeveloperCommented:
Please see the attached macro-enabled PowerPoint file and corresponding Excel data file.

The PowerPoint file has a slide with 3 named shapes. Running the macro will open the Excel file and get the resize data for the 3 shapes and resize them.

There is no error management for missing file, shapes, data etc. but this shows how it could be done.

Files are here : https://filedb.experts-exchange.com/incoming/ee-stuff/8416-Shape-Size-Data.xlsxhttps://filedb.experts-exchange.com/incoming/ee-stuff/8415-Resize-Shapes-using-Excel-data.pptm
0
 
Ed MatsuokaPartner/Senior IT SpecialistAuthor Commented:
Thanks, Jamie! This is going to really be useful. Have a great day.
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.