+ Reply to Thread
Results 1 to 9 of 9

UPdating Macros for Windows 10

  1. #1
    Registered User
    Join Date
    04-28-2017
    Location
    United States
    MS-Off Ver
    2013
    Posts
    19

    UPdating Macros for Windows 10

    I have a new computer with windows 10 and I am trying to use a 2007 Excel workbook that was created on windows 7. The macros will not work on the new system. What can I do to try an get the macros working for windows 10?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: UPdating Macros for Windows 10

    What do the macros do? What error(s) do you get? Most likely to be references if you've also updated your version of Office
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-28-2017
    Location
    United States
    MS-Off Ver
    2013
    Posts
    19

    Re: UPdating Macros for Windows 10

    When I open up the workbook I can't click on my macro buttons and when I click on the enable macros it takes me to the following attached picture.

    Capture.PNG

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: UPdating Macros for Windows 10

    Well LCase isn't going to have changed so it's something else. The errors you get don't always point you to the true issue.

    In the VBA Editor, click on Tools | References and see if there are any "Missing References". If there are, untick them and find and tick the equivalent references for your version of Office/Excel

  5. #5
    Registered User
    Join Date
    04-28-2017
    Location
    United States
    MS-Off Ver
    2013
    Posts
    19

    Re: UPdating Macros for Windows 10

    This is the error that keeps popping up. Capture.PNG

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: UPdating Macros for Windows 10

    That's just a User Defined Function that makes use of LCase. Nothing there that should cause an error.

    Can you upload a sample workbook?

  7. #7
    Registered User
    Join Date
    04-28-2017
    Location
    United States
    MS-Off Ver
    2013
    Posts
    19

    Re: UPdating Macros for Windows 10

    Sorry can't I share the workbook. It's copyrighted and not my property. I'll just have our IT guys see if they can figure it out. Thank you for trying to help.

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: UPdating Macros for Windows 10

    Hi,

    As TMS said earlier, you need to check the references for that project- one (or more) of them is missing.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  9. #9
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: UPdating Macros for Windows 10

    Hi ruddellq,

    I have often hit problems when using a code in a different Excel version caused by things going to a default library that is missing.
    I have not hit the problem yet with
    LCase

    But it is worth a quick try doing
    VBA.LCase
    Instead of
    LCase
    That is a simple solution that has often got me over a lot of niggly problems like the one you have

    I tend to liberally chuck an extra VBA. before a lot of string functions like
    Left
    Mid
    Right
    etc. - Those are mostly the functions that can catch you out on an issue like yours.

    That belt and braces approach has served me well. ( Adding an extra VBA. is the Braces – the Belt is the checking your libraries reference issue, as TMS and xlnitwit have said , (By the way, I am not too sure how to add a missing library...)).

    By the way, I think it is an Office version issue, not a Windows version issue.
    I see you have marked the Thread as Solved.
    Please let us know what your solution was and what the problem was, thanks….

    Alan

    ( P.S. I expect the route of the problem could be that some libraries may be used by applications other than Excel so they have some functions in them that are also in Excel VBA. To aid in the use of the library in those applications something is set to “go to” the function in that library, rather than to “go to” the standard Excel VBA Library. Adding the VBA. overrides that default setting. I would welcome any input from anyone to set me straight on this little Theory of mine )
    Last edited by Doc.AElstein; 10-23-2017 at 04:14 AM.
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ 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] Help please: User form not updating on Windows 7 Excel 2016
    By Andrew Entee in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-08-2017, 02:42 PM
  2. [SOLVED] Updating macro to close pop-up windows.
    By JasonNeedsHelp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2014, 01:59 PM
  3. [SOLVED] Enable / Disable Macros behaving differently in Excel 2003 from Windows XP to Windows 7
    By TC1980 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-21-2013, 09:09 AM
  4. Macros - Coding Macros - Windows Folder Listings
    By theprofessionalnyc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2013, 02:16 PM
  5. Macros created in Windows XP not opening /working in Windows 7
    By Janane in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2012, 04:28 AM
  6. choosing from email2,email1 in the list and updating the windows id and datetime
    By santo_excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2010, 10:28 AM
  7. Windows Macros / Windows Automation
    By dvent in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2008, 11:59 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