VBA in Office 365 and Windows 11

[MrProfessor]

Hi, I have just upgraded my computer from Windows 10 to Window 11 and from MS Office 2010 to Office 365. I am trying to use 2010 Excel Macro (VBA) in Excel 365 and coming up with "Opening the VBA Project in this file requires a component that is not currently installed. This file will be opened without the VBA project. For information, search Office.com for "VBA Converters""
PLEASE HELP

 

[ISY]

Hi

Percorsi attendibili per i file di Office - Deploy Office

Fornisce indicazioni agli amministratori di Office sui percorsi attendibili nelle app di Office.

learn.microsoft.com

 

[Peter_SSs]

@ISY
Postings (& link responses) in this forum should be in English only please.

 

[MrProfessor]

I cannot run Excel 2010 VBAs (which are protected) in Excel 365. I get this message "Opening the VBA Project in this file requires a component that is not currently installed. This file will be opened without the VBA project. For information, search Office.com for "VBA Converters"". Any help would be greatly appreciated.

 

[jkpieterse]

You are apparently opening a very old file, I suspect in .xls file format, created in a very old Excel version. If you still have access to your old computer, try saving-as the file to the xlsm file format.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: USING Office 2010 VBA IN OFFICE 365 WILL NOT WORK
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[MrProfessor]

You are apparently opening a very old file, I suspect in .xls file format, created in a very old Excel version. If you still have access to your old computer, try saving-as the file to the xlsm file format.

Do I just change the extension name in the old laptop from *.xls to *.xlsm and insert in the new laptop? Please advise.

 

[MrProfessor]

Do I just change the extension name in the old laptop from *.xls to *.xlsm and insert in the new laptop? Please advise.

Sorry, it is xla file and not xls file

 

[jkpieterse]

On the old machine:

1. open the xla file
2. open the VBA Editor
3. Find the VBA project of the xla file
4. expand it
5. Double-click the ThisWorkbook entry
6. Find the IsAddIn property and set it to FALSE
7. go back to Excel
8. do a file, Save as to the xlsm format

On the new machine:

1. open the newly saved xlsm file
2. do a save-as to the xlam format.

 

[MrProfessor]

On the old machine:

1. open the xla file
2. open the VBA Editor
3. Find the VBA project of the xla file
4. expand it
5. Double-click the ThisWorkbook entry
6. Find the IsAddIn property and set it to FALSE
7. go back to Excel
8. do a file, Save as to the xlsm format

On the new machine:

1. open the newly saved xlsm file
2. do a save-as to the xlam format.

In the VBA Editor I tried to expand it and the message is "Project is unviewable".