Hi,
Is there a way to use VBA to save the current Word Document's Theme as a file in a location that I choose?
Essentially VBA code to do the same as clicking on this:
Background: I'm working on an Excel macro that uses VBA coding to take a template document, make a copy of it and replace several items within the copy. My problem is the new copy doesn't have the same theme as the original (i.e. accent colors, etc.). My current setup: I've manually saved the theme ".thmx" somewhere and I'm using this line to load the saved theme: myDocument.ApplyDocumentTheme Filename:=myThemeLocation which works. I'm now trying to use VBA to save the original document's theme in case I change the theme later on.
My plan is to use this code so the macro opens template document, saves theme somewhere, apply it to copied document, then deletes the saved theme.
I'm using Word and Excel 2010.
Thanks
Is there a way to use VBA to save the current Word Document's Theme as a file in a location that I choose?
Essentially VBA code to do the same as clicking on this:
Background: I'm working on an Excel macro that uses VBA coding to take a template document, make a copy of it and replace several items within the copy. My problem is the new copy doesn't have the same theme as the original (i.e. accent colors, etc.). My current setup: I've manually saved the theme ".thmx" somewhere and I'm using this line to load the saved theme: myDocument.ApplyDocumentTheme Filename:=myThemeLocation which works. I'm now trying to use VBA to save the original document's theme in case I change the theme later on.
My plan is to use this code so the macro opens template document, saves theme somewhere, apply it to copied document, then deletes the saved theme.
I'm using Word and Excel 2010.
Thanks
