Getting date from a Excel range

[lostruler]

Guys,

In a Excel file, Sheet1, cel D13, i have a date (Ex. 13/05/2015).

How can I rename this file, without opening it, using that date, like "FileName_2015_05_13.xls" ?

Thank you.

[Gintaras]

Macro Macro2705

Code:

Copy      Help

str file="$documents$\Book1.xls"

ExcelSheet e.Init("Sheet1" 8 file)
str s=e.Cell("D13")
e.Close
;out s
str path.getpath(file) name.getfilename(file) ext.GetFilenameExt(file)
s.ReplaceInvalidFilenameCharacters("_")
str name2.from(name "_" s "." ext)
;out name2
ren* file name2

[lostruler]

Perfect.Thank you again. Your support is always perfect.