Convert workbook with Macros and VB

Copper Contributor

Currently I have a workbook in excel 2007 with macros and VB components.

How can I convert this workbook to the latest version of Excel?

2 Replies

@Ed_SwartSwart2115 

In most situations, the latest version of Excel will be able to open, edit and save the workbook without problems.

Open the workbook in the latest version of Excel.

If you see [Compatibility Mode] in the title bar, select File > Info. then click the Convert button.

S1588.png

If you don't see [Compatibility Mode], the workbook doesn't need to be converted.

@Ed_SwartSwart2115 

 

How to Save Workbooks in Excel

(This is a none Microsoft Site)

 

Click the File tab.
Click Save As.
The default file type is an XLSX Excel file, but you can choose from plenty of other file formats in this menu.
Select the desired format.

Click Save.