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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ed MatsuokaPartner/Senior IT SpecialistAuthor Commented:
Thanks, Jamie! This is going to really be useful. Have a great day.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft PowerPoint

From novice to tech pro — start learning today.