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
;
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!