Steve Tinsley
asked on
Copy Office XML Colour Palette to new PC using script
My company has recently re-branded and I have created new PowerPoint, Excel and Word templates.
In Office I have created my colour palettes which are very useful, but these dont go across with the PowerPoint/Excel/Word files.
Ive been looking into it and it create an XML file on the machine with all the colours within that palette.
C:\Users\user\AppData\Roam ing\Micros oft\Templa tes\Docume nt Themes\Theme Colors\Name.xml
I would like an easy way for everyone else in the company to copy this XML onto their computer.
Can this be done with a batch script??
Any advice?
Steve
In Office I have created my colour palettes which are very useful, but these dont go across with the PowerPoint/Excel/Word files.
Ive been looking into it and it create an XML file on the machine with all the colours within that palette.
C:\Users\user\AppData\Roam
I would like an easy way for everyone else in the company to copy this XML onto their computer.
Can this be done with a batch script??
Any advice?
Steve
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No Active Directory. It will be something that we can email out.
Thanks for the script idea.... Because it will be emailed out the xml needs to be in the script.
I thought something like this... But ive got no idea now to do any error checking. Check for success etc....
Will this work? Any ideas how to improve?
Thanks for the script idea.... Because it will be emailed out the xml needs to be in the script.
I thought something like this... But ive got no idea now to do any error checking. Check for success etc....
@echo off
setlocal
@echo on
ECHO ===== COLORS =====
@echo off
SET SCRIPTXMLNAME=SCRIPT_COLOURS1
SET SCRIPTPATH=%APPDATA%\Microsoft\Templates\Document Themes\Theme Colors\
SET SCRIPTFILENAME=SCRIPT_COLOURS1.xml
SET SCRIPTFULLPATH="%SCRIPTPATH%%SCRIPTFILENAME%"
@echo on
ECHO Creating XML File
@echo off
ECHO ^<!-- COLOURS --^> >%SCRIPTFULLPATH%
ECHO ^<?xml version="1.0" encoding="UTF-8" standalone="yes"?^> >>%SCRIPTFULLPATH%
ECHO ^<a:clrScheme xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" name="%SCRIPTXMLNAME%"^> >>%SCRIPTFULLPATH%
ECHO ^<a:dk1^>^<a:sysClr val="windowText" lastClr="000000"/^>^</a:dk1^> >>%SCRIPTFULLPATH%
ECHO ^<a:lt1^>^<a:sysClr val="window" lastClr="FFFFFF"/^>^</a:lt1^> >>%SCRIPTFULLPATH%
ECHO ^<a:dk2^>^<a:srgbClr val="37393A"/^>^</a:dk2^> >>%SCRIPTFULLPATH%
ECHO ^<a:lt2^>^<a:srgbClr val="8C827E"/^>^</a:lt2^> >>%SCRIPTFULLPATH%
ECHO ^<a:accent1^>^<a:srgbClr val="006EB6"/^>^</a:accent1^> >>%SCRIPTFULLPATH%
ECHO ^<a:accent2^>^<a:srgbClr val="00A97A"/^>^</a:accent2^> >>%SCRIPTFULLPATH%
ECHO ^<a:accent3^>^<a:srgbClr val="7CCBE2"/^>^</a:accent3^> >>%SCRIPTFULLPATH%
ECHO ^<a:accent4^>^<a:srgbClr val="6679BA"/^>^</a:accent4^> >>%SCRIPTFULLPATH%
ECHO ^<a:accent5^>^<a:srgbClr val="E6224F"/^>^</a:accent5^> >>%SCRIPTFULLPATH%
ECHO ^<a:accent6^>^<a:srgbClr val="C8B9AF"/^>^</a:accent6^> >>%SCRIPTFULLPATH%
ECHO ^<a:hlink^>^<a:srgbClr val="006EB6"/^>^</a:hlink^> >>%SCRIPTFULLPATH%
ECHO ^<a:folHlink^>^<a:srgbClr val="954F72"/^>^</a:folHlink^> >>%SCRIPTFULLPATH%
ECHO ^</a:clrScheme^> >>%SCRIPTFULLPATH%
endlocal
Will this work? Any ideas how to improve?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you build the color theme into the template (or theme), then they'll travel with the file and you won't need to install them on everyone's computer.
https://www.experts-exchange.com/articles/29126/Deploy-single-EXE-applications-without-installers.html