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

 

[jkpieterse]

In that case you could try to enter this in the immediate pane of the VBA editor:

workbooks("your-add-in-Name-goes-here.xla").SaveAs "you-path-goes-here-\your-add-in-Name-goes-here.xlam",xlOpenXMLAddIn

and press the Enter key. That should save-as the .xla file to .xlam.