+ Reply to Thread
Results 1 to 4 of 4

backup and restore excel macros issue!

  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Unhappy backup and restore excel macros issue!

    ok, I went to "XLSTART" and saved a copy of "PERSONAL.XLSB", then I reset my laptop to factory settings for some reason!

    Now when I put back my backup ("PERSONAL.XLSB") which contains all of my VBA macros!
    and lunch excel, it says file corrupted!
    any help I'll be appreciated

    excel alert:
    "Excel cannot open the file 'PERSONAL.XLSB' because the file format or file extension is not valid, verify that the file has not been corrupted and that the file extension matches the format of the file."

    I tried to record a simple macro and its working and then replaced the file with the old one and i got the same error msg from excel!

    2020-08-18_4-29-06.png

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: backup and restore excel macros issue!

    Can you attach the file here, if there is nothing private in it? I have not tried a recovery of a corrupted xlsb file but we might be able to help.

  3. #3
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: backup and restore excel macros issue!

    Quote Originally Posted by 6StringJazzer View Post
    Can you attach the file here, if there is nothing private in it? I have not tried a recovery of a corrupted xlsb file but we might be able to help.
    I wish I could, but I have a lot of sensitive information there

  4. #4
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: backup and restore excel macros issue!

    I posted my question in Microsoft Form, and unfortunately, I did not get the answer yet.

    https://answers.microsoft.com/en-us/...9a41937&page=2

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel - VBA - 2 Joined macros not working - MsgBox issue - Please help!
    By kcc2009 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-16-2016, 06:12 AM
  2. Access database backup & restore demo project
    By Parth007 in forum Access Tables & Databases
    Replies: 1
    Last Post: 01-18-2016, 09:56 AM
  3. Weird issue with VBA IDE - all module windows maximize/restore size
    By PegLegPete in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2015, 05:20 PM
  4. Backup problem of Excel file after the execution of macros
    By aliel15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2015, 01:12 PM
  5. Auto Backup Issue
    By Mike McCann in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-22-2015, 02:25 PM
  6. Backup/Restore Clipboard
    By Kris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2006, 03:55 PM
  7. [SOLVED] Backup:always create a backup file in the save options
    By Alek in forum Excel General
    Replies: 1
    Last Post: 01-07-2006, 09:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1