xlsm workbook will not open

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

xlsm workbook will not open

Post by ABabeNChrist »

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?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: xlsm workbook will not open

Post by HansV »

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?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: xlsm workbook will not open

Post by HansV »

Has the VBA project been protected? If so, do you know the password?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

Yes and yes

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: xlsm workbook will not open

Post by HansV »

So, activate the Visual Basic Editor, and enter the password when asked.
Then select Debug > Compile <projectname>
Does that provide a clue?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

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

Message - Copy.jpg
Error message 1 - Copy.jpg
Error message - Copy.jpg
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: xlsm workbook will not open

Post by HansV »

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?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

I just tried debug > Compile
I received an error message
Compile error:
Cant find project or library

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: xlsm workbook will not open

Post by HansV »

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.
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

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
New error message.jpg
Then I ran debug with this error message
New error message 2.jpg
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.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: xlsm workbook will not open

Post by HansV »

What happens if you tick the check box for "Microsoft Office 14.0 Object Library" again?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

It will stay until you run debug again then the check box is unchecked once more

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: xlsm workbook will not open

Post by HansV »

Weird. Can you attach the workbook, or send it to me (I think you have my email address)?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

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

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: xlsm workbook will not open

Post by HansV »

It's worth a try.
Best wishes,
Hans

snb
4StarLounger
Posts: 548
Joined: 14 Nov 2012, 16:06

Re: xlsm workbook will not open

Post by snb »

Make a screencopy using Alt-Print Screen.
Then paste in Paint and saveas As PNG file.

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

snb wrote:
22 Jan 2023, 09:56
Make a screencopy using Alt-Print Screen.
Then paste in Paint and saveas As PNG file.
Sorry for the poor images they were sent to me like this.

snb
4StarLounger
Posts: 548
Joined: 14 Nov 2012, 16:06

Re: xlsm workbook will not open

Post by snb »

You can help your friend to improve his 'windows' skills by passing my suggestion.

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: xlsm workbook will not open

Post by ABabeNChrist »

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.
Setup error.jpg
You do not have the required permissions to view the files attached to this post.