[QUOTE 2312604, member: 9609"]I need a file to always exist in two different folders, basically, every time the file in 'folderA' is changed, an exact copy will be created in 'folderB'
Can anyone think a way of automating this?
Currently I use an automatic sub in excel, but this means that unless I open a certain file in excel the operation does not take place.[/quote]
try (open notepad)
copy /y "d:\users\gemima\documents\won again.jpg" d:\users\gemima\documents\copy
replace file & folder names as needed.
quotes are in on the first location to accommodate the space in the filename I randomly picked. edit as needed and if folders have a name with quotes for destination, then include quotes there as well.
the /y will automatically overwrite the existing file... if you want to confirm each and everytime, use /-y instead.
now save this as backup.bat either on your desktop or a shortcut to somewhere useful on your desktop...
run it as and when you need to and it will copy the contents from one location to the other the caveat being that the excel file must not be open at the time. lot quicker than locating the file and copying to said folder.
Also what version of Windows 7 are you on... I ask because with the pro version you could also have the previous versions option setup to allow restores of that file to various points in time.