Power Point to Excel

**fretwizard** · 04-06-2009, 06:32 AM

Hey guys! There are a host of ways to get excel charts and info from excel to power point, and the VB is what I have learned to use for automation sake....

However, I keep metrics at my work, and need to start incorporating other departments information in my access database. One of the easiest ways (relative to your answers) it seems for me to get some of that, is take their weekly powerpoint presentations and enter them in.

So is there a method for getting data from power point in to excel rather than the other way around (aside fo course, from the good old copy and paste)? Does anyone know a Visual Basic approach, or know where I might find a tut on this?

I have looked for a bit and find nothing....thanks for your efforts guys!

justin

**broro183** · 04-06-2009, 10:57 AM

hi Justin,

This really doesn't answer your question but it's my two cents worth...

When reporting metrics, the fewer the parties/steps involved the more likely that data integrity is maintained (think of it like a game of Chinese whispers!) so I suggest talking to the Heads/Managers of the other departments about their source data.

It is very likely that they already/initially have the information in Excel files before putting it into the Powerpoint presentations. Or, you may even find out that they already have their own access databases & you may be able to source/link your figures directly to the Primary source data.

hth
Rob

**fretwizard** · 04-06-2009, 05:08 PM

I appreciate the response.

Thing is, I can huge amounts of data from several departments, and yes most of the raw extractions come in excel workbooks, but we are talking a very large amount of tracking, and even large source. using nothing but excel is really not feasible. for example most of the time i get a single dump from one of fifty sources, it is too big fro excel to hold. so i get a txt doc that I run some script against to break it into smaller excel files because then it is easier to normalize a bit before i start appending tables all day long.

not only that but the variables that go into these reports are taken from tons of sources, and i had to give the customer a user interface which meant i really had no choice....

anyway, i need a method on the back end. but i do thank you!

**Andy Pope** · 04-07-2009, 05:20 AM

You can use code to extract information.
The hard part is knowing where and in what the information is stored.

Are the values in textboxes, tables, msgraph object, embeded excel object etc...?