SaveAs

concerns

The SaveAs attribute function stores the variable's Excel workbook in the file system under a different name. The Excel workbook remains in the server's access and write accesses are denied. However, pending changes will now be saved under the new name. Only when the server instance is finished the workbook can be edited.

 

Syntax

SaveAs(ByVal Path As String, Optional ByVal Format As ExcelFileFormats)

Return value

Long

0 if successful

Parameter

Use

Name

Type

Passing

Description

Required

Path

String

ByVal

Path and file name under which to save the Excelsheet.

Optional

Format

ExcelFileFormats

ByVal

File Format Collection