Running old Excel macros in Windows 7


  1. MCK
    Posts : 2
    Windows 7 professional 32 bit
       New #1

    Running old Excel macros in Windows 7


    I have quite a few macros written in older versions of excel that now won't run on our Windows 7 machines. Getting the error that the library is not found. I assume this is an issue with the new "Library" function in Windows 7. Does anyone know what to do to run these? From what I have found, there is not a way to turn off the Library function.
      My Computer
    Quote Quote

  3. DeaconFrost
    Posts : 5,795
    Windows 7 Ultimate x64 SP1
       New #2

    It is more than likely referring to a missing .dll file...not the Libraries (folder groups) in Windows 7. What version of Excel where they created in...and what's installed on the new system?
    Last edited by DeaconFrost; 01 Nov 2010 at 14:24.
      My Computer
    Quote Quote

  4. MCK
    Posts : 2
    Windows 7 professional 32 bit
    Thread Starter
       New #3

    The macros were written in Excel 97 which is also installed on this particular machine. They do, however, also work in Excel 2007 which I have running on a virtual XP machine. The '97 Macros worked fine in XP. Thanks for any ideas you can give me.
      My Computer
    Quote Quote

 

  Related Discussions
Excel Warnings - Macros
in Microsoft Office

I have an Excel Workbook that I use a lot. As far as I know, the workbook doesn't contain any macros but I continue to get this message: C:\Users\AccountName\Documents\Spreadsheet.xls contains macros. Macros may contain viruses. It is always safe to disable macros, but if the macros are...
enabling macros in Excel
in Microsoft Office

to enable macros in Excel I have to go to Developer then enable macro. Err message ordering me to exit the file, then re-enter it and repeat the "enabling" procedure. This does not always remedy the problem. I have to restart the computer... then go back to my Excel worksheet. However, now...
Hi all, I've got a series of Excel 2003 spreadsheets with macros. They run just fine on a Windows XP machine. However, we recently moved them to a Windows 7 Pro machine. We still run them in Excel 2003, only now on a Windows 7 system. Problem is, they don't run right. No errors, but the one...
Excel Macros Disabled Under W7
in Microsoft Office

Last week, I received a new notebook with Win 7 professional as OS - :o New to me and I feel way behind time noting the posting dates on the forum. Then there is reference to W8 :shock: I have been developing a program in Excel since 1995, improving the macros and output worksheets as I go along....
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 15:53.
Find Us