ExpClose method

Close any export workbook and save as an Excel binary workbook, returning path and name.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
		✓

Parameters

Name	Type	Description
TempDays	Long (optional)	Retention period for exported files.

Any exported file is closed and saved as an Excel binary workbook, and the filename and path are returned. This return value can be used in a Connect call to connect to the exported workbook.

The workbook is saved in the {5F7C1E42-9770-4305-9A47-B3939E267E9B} subfolder of the user's temporary directory.

The method deletes any workbooks in this folder older than TempDays days.