windows 10 download wont let macros work

August 10, 2015 at 07:19:44
Specs: Windows 7
Hi there,
I have just downloaded the update for windows 10
I have an intricate workbook with a number of formulas and macros
The workbook does not know work as it has done since the download, errors in the vba's keep appearing
I still have a copy of the workbook on an old laptop with windows 7 and still works fine

Any ideas


See More: windows 10 download wont let macros work

Report •

#1
August 10, 2015 at 08:03:09
1. Did the program (is it Microsoft Office Excel and if so which version?) ever work on Windows 10 before you downloaded the update?
2. Did you visit Windows 10 Compatibility Center to find out what will and will not work before you upgraded to Windows 10?

i_Xp/Vista/W7/W10 User

message edited by XpUser


Report •

#2
August 10, 2015 at 08:41:25
Hi XpUser,
The version of Microsoft office was 2007.
Basically I have a new Computer for which I have transferred all my Excel workbooks from the old to the new via a memory stick.
As far as I was aware, the Compatability Centre confirmed that it was compatable with Windows 2007
Having done a "Check Compatability' run, there seems to be numerous issues not supported by earlier versions, not sure why this would cause me problems

Report •

#3
August 10, 2015 at 09:07:38
I have transferred all my Excel workbooks from the old to the new via a memory stick.

Did you also reinstalled Office 2007 on the new computer? If not this is what you need to do to access the workbook. There is no other way.

i_Xp/Vista/W7/W10 User


Report •

Related Solutions

#4
August 10, 2015 at 09:11:39
Ok, i take that on board
As a relative novice with computers, a wuick run down if how to reinstall would be much appreciated

Report •

#5
August 10, 2015 at 09:17:04
Do you have the original Office 2007 installation DVD? If so you will also have to have the unique Product key handy. Otherwise Office 2007 will not install.

i_Xp/Vista/W7/W10 User

message edited by XpUser


Report •

#6
August 10, 2015 at 09:20:20
No, fon not have the key

Report •

#7
August 10, 2015 at 09:22:10
Sorry there is nothing more we can do to help.

i_Xp/Vista/W7/W10 User


Report •

#8
August 10, 2015 at 09:25:14
Ok, not your prob,

Report •

#9
August 10, 2015 at 10:04:01
On second thought - you can go HERE and try the free, open-sourced LibreOffice. Personally I can't vouch for this software and all of its features since I never had a reason to try it. Good luck.

i_Xp/Vista/W7/W10 User


Report •

#10
August 10, 2015 at 11:29:53
errors in the vba's keep appearing
Do I get to pick the errors you're getting, or . . . ?

How To Ask Questions The Smart Way


Report •

#11
August 10, 2015 at 11:54:38
Hi Razor2.3
When i say errors keep occuring, it seems that a vba that worked in office 2007 doesnot want to work correctly in the 2010 upgrade, the coding is not being accepted
This has distorted the use of the workbook and how it operates
An example, working on sheet13, click on aform button to process that info on that page and carry out what is required, and then parts of sheet1 can be seen
That does not seem right, any ideas

Report •

#12
August 10, 2015 at 16:55:30
the coding is not being accepted
As in it refuses to run, or running and giving incorrect results?

How To Ask Questions The Smart Way


Report •

#13
August 11, 2015 at 00:36:04
In as much as certain vba's, and there are numerous, come to a point where the code us not accepted
So what is happening with the code in windows 10, wirks perfectly in windows 7

Report •

#14
August 11, 2015 at 05:16:35
Have you checked the references to ensure there are no 'missing' entries and also to ensure all requird references are selected.

in the VBA IDE go to

Tools
References

and make sure everything you need is selected and none of the selected references is prefixed with 'MISSING'


Report •

#15
August 11, 2015 at 05:35:41
Have had a look as suggested, but would not know what references are required
Further help would be appreciated

Report •

#16
August 11, 2015 at 05:49:26
Why not compare the references to the ones on a working machine?

Also have you checked that macro security is set to either

'Disable all macros with notification'
or
'Enable all macros'

also can you describe exactly what happens when you run the code? if you get errors please tell us what they are exactly.. the more info you provide the easier it is for us to try and help resolve.


Report •

#17
December 26, 2015 at 15:15:11
not sure how far you got with this, but I am just trying to run VB (actually overblown Macros) from a Win XP environment to Win 10. Main issues are:
Several keywords, like Str() Mid() Left() Right() Date Case and so on, need to be preceded by typing VBA.Str() VBA.Date and so on
Also, while under XP the code was very forgiving, there is now no mercy for not declared Variables, Variants, and so on.

Still struggling with more things, though....


Report •

Ask Question