How to create a new excel file at a targeted destination path?

[tonysing]

Hello guy, I am a new user of Autoit and encounter some question when writing a script
I want to read the file in a selected folder, record down file name, modified time etc. and write these data into a newly create excel file.
Here is how I do it now

_ExcelBookSaveAs($oExcel,$ScriptPath)
Sleep(1000);To allow the excel file save properly and ready to move
FileMove($ScriptPath,$DestPath)

This method works.

But I want to create the excel file at the $DestPath directly.

Function FileWrite and FileOpen seems help, but I am not really clean of how to use them.

Can anybody give me a example? Thanks a lot !

[November]

Hi and welcome,

Why not this?

_ExcelBookSaveAs($oExcel,$DestPath)

Cheers

[water]

Welcome to Autoit and the forum!

Which version of AutoIt do you run?

[tonysing]

ver : 3.3.8.1

November: As my $DestPath is not at the same directory with my script, so I want to find a better way to save the file.

[water]

What's the value of $Destpath? The 3.3.8.1 Excel UDF is a bit picky about this parameter.