ListExportAsExcel(listboxName As String, optional listTitle As String)

 

Shows a File Save As dialog window, where the user can enter a name for the new Excel file to be created. The contents of the listbox with listboxName will be exported to the new Excel file.

 

Columns and column widths will be exported as set in listbox listboxName.

 

Hint: ListExportAsExcel can be called without the use of any paramters. In this case the listbox of the currently active module (addresses, events, infos, items, finances or locations) will be exported.

   

Parameters:

 

Name	Type	Value	Description
listboxName	String	Listboxname	ScreenFieldName of Listbox to export. Ctrl+Click onto Listbox to retrieve listboxName (= ScreenFieldName)
listTitle	String	Any text	Optional title to be written on top of the exported list

 

Available in:

 

WindowMain	WindowLink
YES	NO

 

Used in:

 

XojoScript Name	GUID
Export list as Excel file	3EADF39E-76DA-4F62-8C93-C46E5AF78CF8
Export seminar pricelist as Excelsheet	6EAAF74C-0706-40F5-9D8F-F3AFF9C3C074

 

Hint: You can find more references to XojoScripts which make use of this function by sending the following SQL statement to the database:

Select id,GUID, ScriptName,ScriptCode from im_scripts where ScriptCode Like '%ListExportAsExcel%'

 

Example XojoScript:

 

// Export contents of custom listbox as Excelfile

// Parameters:

// 1. ScreenFieldName of Listbox to export (Ctrl+Click Listbox to retrieve ScreenFieldName)

// 2. Optional title for list

 

ListExportAsExcel("imLB_evt_List3","Pricelist")