+ 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 2003,2007,2010
    Posts
    26,084

    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 - Excel Aid

    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 2003,2007,2010
    Posts
    26,084

    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 2003,2007,2010
    Posts
    26,084

    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 Expert xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    4,330

    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.
    Please remember to mark your thread 'Solved' when appropriate.

  9. #9
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Hidden - Scroll to the right in the Code Window '_-
    MS-Off Ver
    Office 2007 2010 PC but Not mac. XP and Vista mostly
    Posts
    3,420

    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
    Last edited by Doc.AElstein; 10-15-2017 at 03:23 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)

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