Skip to content

Latest commit

 

History

History
44 lines (26 loc) · 994 Bytes

Excel.Workbook.FileFormat.md

File metadata and controls

44 lines (26 loc) · 994 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Workbook.FileFormat property (Excel)
vbaxl10.chm199100
vbaxl10.chm199100
Excel.Workbook.FileFormat
ef722c3c-90ea-9810-b853-a3fff19d5c60
05/29/2019
medium

Workbook.FileFormat property (Excel)

Returns the file format and/or type of the workbook. Read-only XlFileFormat.

Syntax

expression.FileFormat

expression A variable that represents a Workbook object.

Remarks

Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed.

Example

This example saves the active workbook in Normal file format if its current file format is Excel 97/95.

If ActiveWorkbook.FileFormat = xlExcel9795 Then 
 ActiveWorkbook.SaveAs fileFormat:=xlExcel12 
End If

[!includeSupport and feedback]