directory name not to hard code

[satishsure]

I am hard coding the directory name in below.Do we have any alternate way to get the current directory to pass to variable.

I need to load many files weekly once and put them into qvd.

Let  Transfilespath='lib://Operation Files/ Processed Sales \';

      for each File in filelist (Transfilespath&'Load_*.' &'xlsx')

FilesinFolder:

         LOAD

            '$(File)' as Name,

           Text(right( '$(File)', Len( '$(File)' )- len( '$(Transfilespath)')))  as   TransFilenameinFolder,

            FileSize( '$(File)' ) as Size,

            FileTime( '$(File)' ) as FileTime

         autogenerate 1;

     next File