Trouble with VBA to pull Powerpoint table data, store into vba multivariable array and populate excel sheet

[ALPESH_SHAH]

Dear Excel Experts,

I am a novice especially when it comes to excel vba.

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 900"]
<tbody>[TR]
[TD="class: xl63"]ID[/TD]
[TD="class: xl64, width: 32"]Year
[/TD]
[TD="class: xl65, width: 58"]Objective
[/TD]
[TD="class: xl63, width: 34"]Base
[/TD]
[TD="class: xl63, width: 57"]Expected[/TD]
[TD="class: xl63, width: 41"]Actual[/TD]
[TD="class: xl65, width: 42"]Action[/TD]
[TD="class: xl63, width: 73"]% Complete[/TD]
[TD="class: xl63, width: 70"]Investment[/TD]
[TD="class: xl63, width: 77"]Direct Result[/TD]
[TD="class: xl63, width: 87"]Indirect Result[/TD]
[TD="class: xl63, width: 67"]Resources[/TD]
[TD="class: xl63, width: 126"]Expected Completion[/TD]
[TD="class: xl63, width: 75"]Dependency[/TD]
[TD="class: xl63, width: 44"]Owner[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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