Start Free Trial
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
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?
8/22/2022 - Mon
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 ....
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?
ASKER CERTIFIED SOLUTION
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.
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
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.
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.
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent