Aimin Ariff
Member
Guys, so I have doing cicode function, to execute excel file, the the values from the excel and extract it to the tags. The problem is, I dont know how to make it automatically close the excel file after read it. This is my cicode, please help me..
FUNCTION ReadData()
Exec("C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE C:\Users\USER\Desktop\Knowles\L1_Export_List.xlsx",6);
Temp1 = DDERead("Excel","Data Level1","R2C22");
Temp2 = DDERead("Excel","Data Level1","R4C22");
Temp3 = DDERead("Excel","Data Level1","R6C22");
Temp4 = DDERead("Excel","Data Level1","R7C22");
Temp5 = DDERead("Excel","Data Level1","R9C22");
Temp6 = DDERead("Excel","Data Level1","R11C22");
Temp7 = DDERead("Excel","Data Level1","R13C22");
Temp8 = DDERead("Excel","Data Level1","R16C22");
Temp9 = DDERead("Excel","Data Level1","R17C22");
Temp10 = DDERead("Excel","Data Level1","R19C22");
END
FUNCTION enginestart
WHILE (Start = 1) DO
ReadData()
Sleep(3);
END
END
FUNCTION ReadData()
Exec("C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE C:\Users\USER\Desktop\Knowles\L1_Export_List.xlsx",6);
Temp1 = DDERead("Excel","Data Level1","R2C22");
Temp2 = DDERead("Excel","Data Level1","R4C22");
Temp3 = DDERead("Excel","Data Level1","R6C22");
Temp4 = DDERead("Excel","Data Level1","R7C22");
Temp5 = DDERead("Excel","Data Level1","R9C22");
Temp6 = DDERead("Excel","Data Level1","R11C22");
Temp7 = DDERead("Excel","Data Level1","R13C22");
Temp8 = DDERead("Excel","Data Level1","R16C22");
Temp9 = DDERead("Excel","Data Level1","R17C22");
Temp10 = DDERead("Excel","Data Level1","R19C22");
END
FUNCTION enginestart
WHILE (Start = 1) DO
ReadData()
Sleep(3);
END
END