Dear Excel Experts, I am having a challenge in addressing the following problem. Your advice is greatly appreciated.
Background: I have about 40 Powerpoint Files that I need to analyze the data from. These files have the data structured such that there are 3 textboxes and a PowerPoint table with at least 2 rows. I have tried to pull the data in as a string, but was unable to appropriately manipulate it. I then tried using multivariate arrays, but then the data from the PowerPoint table was no longer populating. I have spent over 80 hours trying to figure out how to make it work. I'm posting here, with the hope that someone may be able to help me to solve this problem or guide me in the appropriate direction. Included for download: I have tried a number of routes, but cannot seem to pull together a full solution. I have attached a copy of a powerpoint file, a copy of the attempt as a string, and that as a multivariate as well. I am not picky as to which approach provides the resolution, but wanted to provide both in case one provides an easier avenue to solve. The Strings file has a tab called Goal which outlines that the final product I am working towards. For simplicity I include the table headers below as well. ID Year Objective Base Expected Actual Action % Complete Investment Direct Result Indirect Result Resources Expected Completion Dependency Owner Powerpoint Sample File: https://www.box.com/s/2ef35ca126140242e64b Attempt using Strings: https://www.box.com/s/adc84777949e8170a5f7 Attempt using Multivariate Array: https://www.box.com/s/c465442fc80b1cb28c46 Thank you in advance. Alpesh -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
