PDA

View Full Version : Text export from PPT cells to XLS colums/rows



Fiberflux
02-21-2015, 05:44 AM
Hi all code sharks,
I have a challenge regarding export of text in PPT to dedicated cells in Excel.

I have this setup in PPT:

"Name
Address
City"

Phone:"XXXXXXXXXXXX"
E-Mail: "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"

Bla.bla.bla.............................Ordernumber"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"

In Excel I have the same field/cell names:

Name: 'Blank' (Full name)
'Blank' (Address)
'Blank' (City)

E-Mail: 'Blank'
Phone: 'Blank'

Ordernumber: 'Blank'

The challenge as I see it, is to make a PPAM ribbon buttom. When pushed it extracts the text that I manually marked in PPT and the paste it into the correct cells in Excel. Can it be done?

I hope that I explained myself in a way that makes sense - otherwise ask me what is missing and I will add it.