Powerpoint Presentation

I have an access database that creates and exports a report in Excel format, this has been working for months very well, now I received a request to change the output format to Powerpoint.

I have been copying and pasting data from Excel to PP for a couple of months already but got tired of all the formatting that involves.

I know there is a way to either export my report to PP with the existing requirements and formatting or copy the report image from Excel and paste onto PP or who knows what is the best option or if there are more I do not know.

Sometimes this report may have 2 rows of data or sometimes 20 rows so for each PP slide I create have to keep the header
Sample-Report.xlsx
GONZALO TROYAAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Powerpoint is not really  "Format" you can export to...
A powerpoint file is basically a "presentation", ...not a filetype

Then best you may be able to do is save the report as an image and insert it into a powerpoint slide.
Either that, or export the report "data" to Excel, ...and insert that into a slide.
Or finally save the Excel data to a PDF file and just display that, instead using Powerpoint.

Lets see if other experts may know a bit more.

JeffCoachman
1
GONZALO TROYAAuthor Commented:
Thanks for the clarification. I read about and tried it but no luck. I will wait to see if there are other suggestions.
0
Jeffrey CoachmanMIS LiasonCommented:
At the high end, ...I guess you could create code (in Excel) to do all of the formatting, ....But that might be a question the Excel experts here can answer...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Echo_SCommented:
Does the report have to be editable in PPT?

You can try copying the Excel cells and then using Paste Special in PowerPoint. You'll have various options, one of which is Keep Source Formatting. That might just do what you need.

Access Paste Special at the bottom of the Paste button on the PowerPoint Home tab. Or use the keyboard shortcut CTRL+ALT+V.
1
GONZALO TROYAAuthor Commented:
I apologize for not explaining fully. I am trying to automate this via VBA so any suggestions are welcome but either way I will need assistance in fullfil it - Thanks again
0
GONZALO TROYAAuthor Commented:
I like Jeffrey's approach but not an expert in VBA either
0
Dale FyeCommented:
what version of Office are you using?

You used to (2003 and earlier) be able to paste special a link to an Excel spreadsheet or Chart.  When you opened the PPT file, you would be asked if you wanted to refresh those links, or you could choose to cut the links to persist the data that was displayed when the links were created.

I'm running 2007 on my laptop at the moment, and cannot seem to figure out how to do that with this version.
1
GONZALO TROYAAuthor Commented:
Thank you Dale - Office 2010
0
Dale FyeCommented:
In 2010, if you open Excel, copy the section you want to display in PPT.

Then Open PPT, Click on the Paste icon on the ribbon and select PasteSpecial
Click the PasteLink radio button and select Microsoft Excel Worksheet ObjectLinkPPTtoExcelThen Position the item where you want it on your PPT slide.
1
Echo_SCommented:
@Dale. Insert | Object | Create from File.

Once you save the file you'll be able to Edit Links to Files somewhere on the Office button. (Sorry, my 2007 system died last week so I can't call it up to look.)

In 2013 you can Paste Special and choose Paste Link. Then you Edit Links to File on the File, Info tab.

But I don't think that's what Gonzalo is looking for. He said he wants to do this via VBA. But FWIW, 2010 works the same way as 2013 -- paste special, choose paste link.
0
Dale FyeCommented:
If you right click on the object in PPT, you can open the Excel file by selecting "Linked Worksheet Object => Open
1
Dale FyeCommented:
I'm sure you can do this via VBA, but why when you don't have to?

I created a 20 or 30 page briefing which would automatically update itself from Excel every time the user opened the file.

I had automated Excel via Access to push data to Excel worksheets which were then used as the source of numerous charts.  The Access code ran automatically every morning at about 05:00 AM to pull data from the previous day from our servers.  This worked extremely well.
0
regmigrantCommented:
you can use automation to write the PPT files directly from Access using the information in this link:
https://msdn.microsoft.com/en-us/library/office/aa159920%28v=office.11%29.aspx?f=255&MSPPError=-2147217396
1
Jeffrey CoachmanMIS LiasonCommented:
@    GONZALO TROYA
...as you can see whatever the solution, ...it does not look like it will be be easy.

What the need for this to be in Powerpoint?

Besides, ...if this is Access data, ...then why not just make a report on this data in Access?
You can use conditional formatting to get your "Status" colors.

Going from Access, then to Excel, ...then to Powerpoint, ...just make mew think we can simplify this to one Office application...

just throwing it out there.

JeffCoachman
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GONZALO TROYAAuthor Commented:
Thank you everyone.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.