How to open daily file?

roy92141

Hi, i have a trouble again

system will generate daily file day by day

the file name format as follow :

20130426.xls
20130427.xls
20130428.xls
....

I want to open this daily file day by day

like 4/26 open 20130426.xls , 4/27 open 20130427,xls , 4/28 open 20130428.xls

Anyone can help me how to write JSL? THX

ms

The Format function can turn a date value into a formatted string.

Example:

mypath="C:\....."; //path to file repository

filename = Format( Today(), "yyyymmdd" );

Open( mypath || filename || ".xls" );