+ Post New Thread
Results 1 to 1 of 1
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, ...
  1. #1


    Join Date
    Jan 2012
    Posts
    2,618
    Thank Post
    934
    Thanked 350 Times in 266 Posts
    Rep Power
    212

    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 01:02 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 27th November 2012, 03:58 PM
  2. Moving exchange mailboxes to a new server on 2 domains
    By darrenmcginnis in forum Internet Related/Filtering/Firewall
    Replies: 0
    Last Post: 17th April 2011, 09:31 PM
  3. Moving SIMS\FMS to a new server
    By matt40k in forum MIS Systems
    Replies: 2
    Last Post: 22nd August 2008, 07:58 PM
  4. Replies: 2
    Last Post: 2nd April 2008, 01:44 PM
  5. Moving Mcafee EPO to a new server
    By manick in forum Network and Classroom Management
    Replies: 2
    Last Post: 5th April 2007, 11:26 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •