XL.ActiveWorkbook.SaveAs() use string as title? Topic is solved

[ivill]

Code: Select all

Loop F:\
{
 If ( A_LoopFileTimeModified >= Time )
{
    Time := A_LoopFileTimeModified
    File := A_LoopFileLongPath
    Filename := A_LoopFileName
}
}
StringTrimRight, Filename, Filename, 4
Sleep 300
if( RegExMatch(Filename, "(.*?)(\d+)$", spli) )
Sleep 300
spli2 := spli2 +1
;
;balabalabala
;

XL.ActiveWorkbook.SaveAs("F:\spli1 . spli2", 56)

how do i put the %spli1%%spli2% as the title while save it as a new .xls?

neither XL.ActiveWorkbook.SaveAs("F:\spli1 . spli2", 56) nor XL.ActiveWorkbook.SaveAs("F:\%spli1%%spli2%", 56) works... (it creates a .xls file called spli1 . spli2 or %spli1%%spli2% )

could someone point out the mistake, thanks!

[Blackholyman]

XL.ActiveWorkbook.SaveAs("F:\" . spli1 . spli2 . ".xls", 56)

[ivill]

XL.ActiveWorkbook.SaveAs("F:\" . spli1 . spli2 . ".xls", 56)

it works like a charm, thanks! @blackholyman