File saved without ".xls" extension when using _ExcelBookSaveAs

[Akshay07]

Hi all,

Here is the piece of code:

$sPath = "C:\test\"&$sTime ; $sTime format is yy.mm.dd-hh.mm.ss
; Run("notepad.exe")
; Sleep(1000)
; Send($sPath)  This is just for testing purpose, to check that $sPath string is correct
$oExcel = _ExcelBookOpen("C:\test\ExcelTest.xls")
_ExcelBookSaveAs($oExcel, $sPath, "xls")

But the file is saved without any extension at all. According to the help, the format to use is _ExcelBookSaveAs($oExcel, $sFilePath, $sType = "xls").

Any clue?

Thanks

[ichigo325]

Hi, i can't test your code because i don't have Excel.. But i think i know how to do it.. Maybe you can use this simple code:

_ExcelBookSaveAs($oExcel, $sPath & $Filename & ".xls", "xls")

[Akshay07]

Thanks, it works.

This is weird because it does not correspond to what the help says.

Anyway, as long as it works, I am happy