Avatar of hindersaliva
hindersaliva
Flag for United Kingdom of Great Britain and Northern Ireland asked on

PowerPoint 2013 store array data VBA

I have a PowerPoint app where I import some tabular data in a CSV file into an array. Of course I need to import the CSV each time I run it.

Is it possible for PowerPoint to store the data in a non-volatile way? For instance, is there a 'spreadsheet' within the PowerPoint 2013 that I can dump the data, so that it will persist?

If so can someone point me some sample VBA code?

Thanks.
Microsoft PowerPointMicrosoft ExcelVBA

Avatar of undefined
Last Comment
hindersaliva

8/22/2022 - Mon
John Wilson

You could store it in a series of presentation Tags maybe. If you post your csv file I can post more code but the basis is ....

ActivePresentation.Tags.Add "Name","Value"
hindersaliva

ASKER
Hi JRSW, I have attached an example of a CSV file I need to import.

BTW I may be wrong but I seem to remember there was a 'spreadsheet object' in PowerPoint at one time that we could access programmatically?
4MeasuresPerSlide.csv
ASKER CERTIFIED SOLUTION
John Wilson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
hindersaliva

ASKER
Thanks JSRW, I'll play around with that.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Stephen Rindsberg

A chart in PowerPoint has a spreadsheet that you can access programmatically, but working with tags is a great deal simpler and more reliable across various PPT versions.
hindersaliva

ASKER
Thanks Stephen. Ah, so that's what I seem to remember (but had forgotten). I'm working on the tags idea. That was new to me.