+ Reply to Thread
Results 1 to 2 of 2

Closed file with macros with same name

  1. #1
    Forum Contributor
    Join Date
    06-29-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2016 (Office 365)
    Posts
    137

    Closed file with macros with same name

    Hi all,

    After copying a procedure a couple of times I closed the excel file without changing the name of the macros, hence it the file closed with some macros with the same name. When I try to open the file again I get a not responding and I can no longer access the file. it also only gives me the option to open the file in read only mode before I then get the not responding.

    How can I now access the file to change the macro names?

    I have spent months working on this file so I desperately need to open it again.

    thanks for your help.

    Marcus

    Can I write some code in a workbook to change the name of a vba procedure in another workbook without opening it????
    Last edited by demarc; 03-13-2016 at 11:35 PM.

  2. #2
    Forum Contributor
    Join Date
    06-29-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2016 (Office 365)
    Posts
    137

    Re: Closed file with macros with same name

    I also get this message when I try to open the file:

    This error may appear if you attempt to open a file marked as damaged or disabled by a Microsoft Office program. Each time the file is opened, even if the file was recovered or repaired, this error appears and other open files or programs will be suspended.

    The file is in the Disabled Items list because, in previous attempts to open the file, it has caused a program error or shut down more than once.

    If the file was properly recovered, replaced, or deleted, you can remove the file from the list of disabled files (re-enable the file) by clicking the File tab, clicking Options, and then clicking Add-Ins. In the Manage list, click the arrow and select Disabled Items, click Go, and then select the disabled item that you want to re-enable.

    Re-enabling a file does not guarantee the application can open it. The file must be recovered from either a backup or undamaged recovered file

+ 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. [SOLVED] BeforeClose event not running/working when file is closed through VBA in another file
    By jaimelwilson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2014, 03:43 AM
  2. [SOLVED] strange sumifs problem, works with file open, #value with file closed
    By neowok in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2013, 05:32 AM
  3. Access and collate macros from closed workbooks
    By freud1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2012, 06:32 AM
  4. Using a closed MS Excel file in Macros
    By mhraja in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-04-2010, 11:57 AM
  5. Do already running macros terminate if the excel workbook is closed?
    By Visceral in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2009, 06:19 PM
  6. Auto Save & Disable/Enable CutCopyPaste MACROS - Make ineffective once file is closed
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2008, 07:30 PM
  7. Search Macros in closed file
    By Roger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2005, 03:05 AM

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