USE main1&& form d:\llocp gcDelimName = ALIAS( ) + '.xls' **gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')&&if active this line return to same dir d:\llocp gcPath = [\\Jtchp58544\new smd\Training\Quality Test 01\] gcDelimName = gcPath + ALIAS() + [.XLS] COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5 SET DEFAULT TO (gcPath) browi try anothr thing i got 3 error messages
SET DEFAULT TO d:\llocp USE main1 gcDelimName = ALIAS() + [.XLS] gcDelimName = ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS]) COPY fields num,Msisdn,date,flag TO TO (gcDelimFile) xl5 &&&Variable "gcDelimFile" is not found COPY fields num,Msisdn,date,flag TO ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])&&&Invalid path or file name COPY fields num,Msisdn,date,flag TO (gcDelimName) xl5 &&&OLE error code 0x800300fc:unknown com status code SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"] brow SET DEFAULT TO d:\llocpthanks
>>USE main1 >>gcDelimName = ALIAS() + [.XLS] >>gcDelimName = ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS]) >>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5 >>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"] >>brow >> >>>