open/process files from directory

[baqs]

Hi,

I have quite a lot of old Lotus files (*.wk3) which I would like to convert to Excel (*.xls)

I can open this files in Excel and just save it in xls file format - easy.

because I have hundreds of wk3 files it will take ages to do it manually.

for Autoit it will be few steps only:

open file

save it

close it

open next file

etc.

but

I able to write the script for single file but how do I process whole folder - open first file, close then open next etc?

that's my script:

Run("C:\Program Files\Microsoft Office\OFFICE11\excel.exe")

WinWaitActive("[CLASS:XLMAIN]", "")

Send("^o")

; here I will need to open file the folder

Send("!f")

send("a")

Send("^s")

;close saved file

;and go back to opening next File

any suggestions much welcome

thank you

[Triblade]

Search the helpfile for: FileFindFirstFile

It has a pretty good example to copy and edit.

[baqs]

Thank you.

will read up on this one!

[Kerros]

Another way would be to use _FileListToArray and a for loop.

I would also suggest using the Excel UDF instead of sending keystrokes. The Excel UDF that most people use is located here.

[erik7426]

This should work. I've attached the compiled version as well as the source and the UDF needed to run the script if you want to compile it yourself.

Convert_WK3_Files.exe

Convert_WK3_Files.au3

Excel.au3

[baqs]

thank you very much it works perfectly!!

now I will need to study a bit to understand how....

thanks again!

:-)