xlsm workbook will not open
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
xlsm workbook will not open
I am having a problem trying to open an xlsm workbook. Previously there was Office 365 online version installed that was not compatible for a macro enabled workbook. I tried uninstalling the 365 and then installed Office 2010 home and student version. The xlsm workbook still will not open up, it resorting to wps office. When I try to use “open with” there is no option to select excel 2010. I know it is installed as I have doubled checked and have enabled the marcos. Any suggestions?
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: xlsm workbook will not open
If you install Office 365, you get locally installed versions of all Office applications. The local version of Excel should be able to handle macros
I don't know anything about WPS Office, but perhaps the workbook has become corrupt?
I don't know anything about WPS Office, but perhaps the workbook has become corrupt?
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: xlsm workbook will not open
I got the workbook to open but now I am getting an error "Compile error in hidden module 2". Even though the workbook macros are enabled, the workbook open seems to display disabled macros
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: xlsm workbook will not open
Has the VBA project been protected? If so, do you know the password?
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: xlsm workbook will not open
Yes and yes
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: xlsm workbook will not open
So, activate the Visual Basic Editor, and enter the password when asked.
Then select Debug > Compile <projectname>
Does that provide a clue?
Then select Debug > Compile <projectname>
Does that provide a clue?
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: xlsm workbook will not open
Here are some error messages that I was receiving
Excuse the quality I had to compress
1st photo is from a xlsm different workbook and the other 2 photos are from the first workbook
Excuse the quality I had to compress
1st photo is from a xlsm different workbook and the other 2 photos are from the first workbook
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: xlsm workbook will not open
Please activate the Visual Basic Editor (Alt+F11).
Try to open any module.
If you are asked to provide a password, enter it.
Then (still in the Visual Basic Editor), select Debug > Compile VBAProject (you may see another name than VBAProject).
Do you get an error message? If so, what does it say,and which piece of code is highlighted?
Try to open any module.
If you are asked to provide a password, enter it.
Then (still in the Visual Basic Editor), select Debug > Compile VBAProject (you may see another name than VBAProject).
Do you get an error message? If so, what does it say,and which piece of code is highlighted?
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: xlsm workbook will not open
I just tried debug > Compile
I received an error message
Compile error:
Cant find project or library
I received an error message
Compile error:
Cant find project or library
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: xlsm workbook will not open
Select Tools > References...
The references that are in use are listed at the top of the dialog; they are the ones whose check box is ticked.
If there are references whose name starts with MISSING:, clear their check boxes.
Then try Debug > Compile again.
The references that are in use are listed at the top of the dialog; they are the ones whose check box is ticked.
If there are references whose name starts with MISSING:, clear their check boxes.
Then try Debug > Compile again.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: xlsm workbook will not open
Ok here are the results
at first the workbook opened with no problems (I removed the VBA password)
When checking the reference selections for the word missing everything liked ok Then I ran debug with this error message I then returned to reference selections and noticed that the "Microsoft Office 14.0 Object Library" now became unchecked
at first the workbook opened with no problems (I removed the VBA password)
When checking the reference selections for the word missing everything liked ok Then I ran debug with this error message I then returned to reference selections and noticed that the "Microsoft Office 14.0 Object Library" now became unchecked
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: xlsm workbook will not open
What happens if you tick the check box for "Microsoft Office 14.0 Object Library" again?
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: xlsm workbook will not open
It will stay until you run debug again then the check box is unchecked once more
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: xlsm workbook will not open
Weird. Can you attach the workbook, or send it to me (I think you have my email address)?
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: xlsm workbook will not open
The funny thing is this workbook works with no problem on my laptop and desktop computer. Its my friends computer that has the problem. He first had the 365 app and then downloaded office 2010. i had him remove the 365 app. I wonder if he should remove all Microsoft office programs and then reinstall the office 2010
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 4StarLounger
- Posts: 588
- Joined: 14 Nov 2012, 16:06
Re: xlsm workbook will not open
Make a screencopy using Alt-Print Screen.
Then paste in Paint and saveas As PNG file.
Then paste in Paint and saveas As PNG file.
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
-
- 4StarLounger
- Posts: 588
- Joined: 14 Nov 2012, 16:06
Re: xlsm workbook will not open
You can help your friend to improve his 'windows' skills by passing my suggestion.
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: xlsm workbook will not open
After uninstalling the Office 2010 home and student and then reinstalling, the macros were then enabled. Upon opening the xlsm workbook everything seem to function as it should, and then all of a sudden it stopped with the same errors codes as before.
Upon trying to uninstall and reinstalling office once more, a new error message comes up during installation. Error 25004. The product key you entered cannot be used on this machine. This is most likely due to previous Office 2010 trials being installed (system error: -1073418160)
Upon Google searching there seems to be all kinds of possibilities. What are your thoughts?
Also, another newer error message came up during the installation process.
Upon trying to uninstall and reinstalling office once more, a new error message comes up during installation. Error 25004. The product key you entered cannot be used on this machine. This is most likely due to previous Office 2010 trials being installed (system error: -1073418160)
Upon Google searching there seems to be all kinds of possibilities. What are your thoughts?
Also, another newer error message came up during the installation process.
You do not have the required permissions to view the files attached to this post.