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
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
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.
ActivePresentation.Tags.Ad