Find theme path from workbook/vba XL2010

[AlisonS]

Hi,

I was wondering if anyone knows of a way to get the path of a theme file from the workbook it's been applied to. (I was hoping for something along the lines of 'ActiveDocument.ActiveTheme' which is available in Word.)

I know that themes need to be in one of two folders in order to appear in the galleries, but they can be applied from anywhere using Workbook.ApplyTheme(Filename). If this has been done, is there any way to find out anything about the theme file that was applied?

Thanks,
Alison

 

[RoryA]

I don't believe that there is any property that would give you that information, I'm afraid.

 

[AlisonS]

Yes, that's the conclusion I was reluctantly coming to, but I thought I'd ask anyway. Oh well. Thanks for replying.

Alison