Modify

Opened 13 years ago

Closed 13 years ago

#2351 closed Feature Request (Completed)

_ExcelBookSaveAs format XLSX (default workbook)

Reported by: slash.cyberpunk@… Owned by:
Milestone: Component: Standard UDFs
Version: Severity: None
Keywords: excel, xlsx Cc:

Description

In beta 3.3.9.2 too.
Add const:

Global Const $xlWorkbookDefault = 51

Change in _ExcelBookSaveAs function in Excel.au3:
Before:

	If $sType = "xls" Or $sType = "csv" Or $sType = "txt" Or $sType = "template" Or $sType = "html" Then
		If $sType = "xls" Then $sType = $xlNormal
		If $sType = "csv" Then $sType = $xlCSVMSDOS
		If $sType = "txt" Then $sType = $xlTextWindows
		If $sType = "template" Then $sType = $xlTemplate
		If $sType = "html" Then $sType = $xlHtml
	Else
		Return SetError(2, 0, 0)
	EndIf

After:

	If $sType = "xls" Or $sType = "xlsx" Or $sType = "csv" Or $sType = "txt" Or $sType = "template" Or $sType = "html" Then
		If $sType = "xls" Then $sType = $xlNormal
	    If $sType = "xlsx" Then $sType = $xlWorkbookDefault
		If $sType = "csv" Then $sType = $xlCSVMSDOS
		If $sType = "txt" Then $sType = $xlTextWindows
		If $sType = "template" Then $sType = $xlTemplate
		If $sType = "html" Then $sType = $xlHtml
	Else
		Return SetError(2, 0, 0)
	EndIf

Attachments (0)

Change History (3)

comment:1 by TicketCleanup, 13 years ago

Version: 3.3.8.1

Automatic ticket cleanup.

comment:2 by guinness, 13 years ago

This is currently in the beta v3.3.9.8.

comment:3 by guinness, 13 years ago

Resolution: Completed
Status: newclosed

Modify Ticket

Action
as closed The ticket will remain with no owner.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.