Link to home
Get AccessLog in
Avatar of GONZALO TROYA
GONZALO TROYA

asked on

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
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of GONZALO TROYA
GONZALO TROYA

ASKER

Thanks for the clarification. I read about and tried it but no luck. I will wait to see if there are other suggestions.
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...
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.
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
I like Jeffrey's approach but not an expert in VBA either
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.
Thank you Dale - Office 2010
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 ObjectUser generated imageThen Position the item where you want it on your PPT slide.
@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.
If you right click on the object in PPT, you can open the Excel file by selecting "Linked Worksheet Object => Open
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.
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
ASKER CERTIFIED SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Thank you everyone.