Posted by Grant Foraker on April 28, 2011 at 12:06:09:
Have a group (13) of $ files that print a variety of reports based on a selected data set. They look like ...
!--------------- DONT CHANGE THE SEQUENCE OF THE FOLLOWING LINES ---------------
INPUT JAHR.AUDIT (JAHR-P01)
PRINTER JAHR0088.TXT,TMP,H
!-------------------------------------------------------------------------------
DEFINE DATE.DD = SUB(REGISTER.DATE,7,2);2
DEFINE DATE.MM = SUB(REGISTER.DATE,5,2);2
DEFINE DATE.YY = SUB(REGISTER.DATE,1,4);4
DEFINE DATE10 = (DATE.MM+'/'+DATE.DD+'/'+DATE.YY);10;DATE
SORT ON EMPLOYEE.NO;JOB.NO;REGISTER.DATE
REPORT
PRINT EMPLOYEE.NO;EMPLOYEE.NAME;JOB.NO;ITEM.NO;DATE10;
REG.HOURS;OT.HOURS;DT.HOURS
!--------------- DONT CHANGE THE SEQUENCE OF THE FOLLOWING LINES ---------------
LAUNCH EXCEL.EXE C:\USERS\JOEYF\APPDATA\LOCAL\TEMP\CATEMP\JAHR0088.TXT
!-------------------------------------------------------------------------------
Since the amount of space for the full file name (derived from the PATH command) is getting close to the CED max, I tried to use an "Alias".
LAUNCH EXCEL.EXE $(CATEMP)\JAHR0088.TXT
There appears to be no substitution in Reporter and Excel tries to open "$(CATEMP)\JAHRTC.CSV" and fails. Is this correct or do I have something wrong in my syntax?
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.