how to get the filename out of the load?

[#1]

I need put on variable a name of excel file....

anyone have some ideia?I look a FILENAME() function....but it works just on load..

tks !!!!!

[colinh]

Hi Erico

Do you want to put the filename into a variable? This should work:

load FileName() as FileName
from "C:\file.xls";

let vFileName = FieldValue('FileName', 1);

FileBaseName() will give you the filename without the extension.

Hope this helps...