xcopy to "%AppData%\Roaming\Microsoft\Excel\XLSTART\" stated copied yet nothing is there

Phairplay picture Phairplay · Apr 8, 2015 · Viewed 14.6k times · Source

I'm trying to write a small bat script to put on my teams desktops and allow them to update their personal macro file with mine when ever I push out an update or have created new tools.

I have the following

xcopy "O:\abc Supply chain\Supply Chain Team\David Peters\Excel\Macro File" "%AppData%\Roaming\Microsoft\Excel\XLSTART\" /y

under CMD is says 1 files copied yet there isn't anything in the XLSTART folder.

can you pleased tell me what I'm doing wrong

many thanks

Answer

MC ND picture MC ND · Apr 8, 2015

Not sure about your configuration, but for me the Roaming folder is already included in the value of the %AppData% variable.

"%AppData%\Roaming\Microsoft\Excel\XLSTART\"
           ^......^ 

So, probably you should use "%AppData%\Microsoft\Excel\XLSTART\"