Writing a simple batch file to back up .xlb file

[Adrian1]

I have written the following batch file to re-instate my default toolbars in excel should my machine go on the blink (thanks to drafter for earlier info!!):-

cd r:\
copy hall02a8.xlb c:\winnt\

when I am in a normal dos window, this works fine and copies the file from my shared drive on the network to my C: drive on this PC. When I run the batch file though, nothing seems to happen. Surely it should work as the commands are exactly the same. Anyone got any ideas?

 

[BrianB]

1. Need to run from a shortcut (not drag file to desktop).
2. Add the word PAUSE as last line when you hopefully see what is going on.

 

[Adrian1]

thanks brian, i'll give that a try!

 

[TryingToLearn]

Knowing that you created the batch file with an ascii editor like Notepad, NOT wordpad so that you don't have control characters in there I would suggest you try using xcopy instead:

xcopy r:\hall02a8.xlb c:\winnt\ /r

This batch file can also be created by typing the following inside of a command prompt window:


copy con fixtoolb.bat
xcopy r:\hall02a8.xlb c:\winnt\ /r
'Ctrl Z'
'Enter'


HTH