4

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

Phairplay
  • 273
  • 2
  • 4
  • 16

1 Answers1

6

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\"

MC ND
  • 69,615
  • 8
  • 84
  • 126