List all external links in a Powerpoint file into a sheet using VBA

[Enter1]

Hello All,

I have an existing presentation (a monthly report) that has various objects (charts, tables) linked to external Excel sources. Can any of you help me with a code that will enable to list all the links into a sheet, may be with the slide number, object dimensions, the underlying cell ranges (which you have answered in my earlier thread) its positions in the slide etc.(sorry I know im asking too much, but thats what my requirement is).

When I speak about position, this is what I meant

Slide NO	Workbook Folder	Workbook Name	Sheet Name	Chart Title	Range	Position	Left	Top	Width	Height
1	J:\Risk\ADMIN\Forecast	Forecast Charts.xls	Mortgages		B12:E26	D1	12	65	335	205
1	J:\Risk\ADMIN\Dlq	Delinquency Charts.xls	Mortgages		I12:M26	D2	362	65	335	205
1	J:\Risk\ADMIN\Forecast	Forecast Charts.xls	Cards		O12:T26	D3	12	278	335	205
1	J:\Risk\ADMIN\Dlq	Delinquency Charts.xls	Cards		V12:AA26	D4	362	278	335	205
2	J:\Risk\ADMIN\Forecast	Forecast Charts.xls	Other Retail		AC12:AH26	A1	15	60	680	422
3	J:\Risk\ADMIN\Dlq	Delinquency Charts.xls	Other Retail		AJ12:AO26	D1	12	65	335	205
		Position Column definition : Eg - if there is only one object in a given slide then the chart / table can be displayed as A1 For a slide containing 2 objects then B1,B2 ; For a slide containing 3 objects then C1,C2,C3 ; and For a slide containing 4 objects (charts/tables) then D1,D2,D3, D4 respectively .. so on till 20 objects as - Slide with 20 objects then T1, T2, .. T20

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5778" span=2 width=158><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2121" width=58><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1133" span=2 width=31><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1609" width=44><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755" width=48><TBODY>
</TBODY>

Truly appreciate you help in this.

Thanks in advance

 

[Enter1]

Hello All,

Can anyone here help me a solution with the above thread (query), basically I want to List all addresses of Powerpoint embedded excel objects / excel chart objects onto an Excel sheet. If possible, in the displayed output format. Kind of stuck at this stage.

Thanks in advance.

 

[Enter1]

Any one can you pls help