View Single Post
 
Old 10-01-2013, 05:23 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Since neither the Style IDs nor their formats in PowerPoint and Excel correspond, you'll need to take a different approach. You could, for example, create a custom style in Excel with the same attributes.

FWIW, on my system (using Office 2010), the PowerPoint Style ID 2A488322-F2BA-4B5B-9748-0D474271808F (which is described as 'Medium Style 3 - Accent 6') doesn't produce a green and orange table. Instead, the table has an orange header row with alternating grey-banded rows below. The Excel equivalent of that is described there as 'Medium 21'. The differences between what you're describing and what I'm seeing in Office 2010 suggests you could run into problems trying to run the code with Style IDs in later Office versions. Accordingly, you should consider creating your own Table Styles for both PowerPoint and Excel, and use those instead.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote