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?
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?
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
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
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
This is the error that keeps popping up. Capture.PNG
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?
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.
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.
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 )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks