11-08-2011, 02:23 PM
Hi Andrea,
Prabhat's solution is good. But if you find it difficult to create environment variables you can us a simplet for loop.
Please refer the below code:
Thanks,
Nandana
Prabhat's solution is good. But if you find it difficult to create environment variables you can us a simplet for loop.
Please refer the below code:
Code:
For i = 1 to 2
if i = 1 then
DataTable.Import("C:\File1.xls")
else
DataTable.Import("C:\File2.xls")
end if
Next
Thanks,
Nandana