Office Software Thread, Excel macros. Moving PERSONAL.XLSB to a new location/it keeps vanishing in Technical; One of our users heavily relies on Excel macros during his daily work. All-of-a-sudden, and we have no idea why, ...
17th June 2013, 02:00 PM #1
Excel macros. Moving PERSONAL.XLSB to a new location/it keeps vanishing
One of our users heavily relies on Excel macros during his daily work. All-of-a-sudden, and we have no idea why, his PERSONAL.XLSB file keeps vanishing. Unfortunately, given that it's naturally generated in %appdata%\etc\etc, it's not backed up by our system (even though it's redirected, we don't bother keeping hold of it). I've been searching high and low for a way to change it, in-program options, registry keys, etc and there doesn't seem to be an option for this, although apparently something similar was available in earlier versions.
For now I've just had to set him up with a batch file that gives him the ability to either
- Backup the current file to his user area on the network, where it will be backed up by our own backups (yo dawg...)
- Restore the file in %appdata%\etc (in the event of it vanishing) by copying the file in his user area previously created by the script.
This solves the problem for now, but isn't exactly ideal. Would anybody know of a better way to sort this out?
Last edited by Garacesh; 17th June 2013 at 02:02 PM.
By Arcolite in forum Windows 7
Last Post: 27th November 2012, 04:58 PM
By darrenmcginnis in forum Internet Related/Filtering/Firewall
Last Post: 17th April 2011, 10:31 PM
By matt40k in forum MIS Systems
Last Post: 22nd August 2008, 08:58 PM
By markman in forum Windows
Last Post: 2nd April 2008, 02:44 PM
By manick in forum Network and Classroom Management
Last Post: 5th April 2007, 12:26 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)