Excel VBA Programming The Complete Guide - Excel File Types

The video tutorial explains the importance of saving Excel workbooks in the correct file format to preserve macro code. It highlights that the default XLSX format does not support macros, and introduces the XLSM format, which does. The tutorial guides viewers on how to set XLSM as the default save type in Excel to avoid losing macro code. It also covers how to change Excel's global settings to streamline this process, ensuring that macro-enabled workbooks are saved correctly throughout the course.

What is the default file extension for Excel that does not support macro code?

• TXT

• CSV

• XLSM

• XLSX

What happens if you save macro code in a regular Excel workbook?

• The code is lost upon reopening the workbook

• Excel automatically converts it to a macro-enabled workbook

• The code is preserved and runs next time

• Excel prompts you to save it as a PDF

What is the file extension for an Excel macro-enabled workbook?

• XLSX

• XLSM

• XLM

• XLS

How can you simplify the process of saving workbooks with macros in Excel?

• Set the default save type to XLSM

• Use the TXT format for all files

• Disable macros in Excel settings

• Always save as a CSV file

Why might you choose not to set XLSM as the default save type?

• It automatically deletes all macros

• It is not compatible with Excel

• It is a temporary file format

• You might not want all workbooks to be macro-enabled