I have several excel sheets in a directory Eg: C:\Data\ExcelFiles
I need to traverse these excel sheets one by one to fetch a particular value in it.
Set varXlSheet = Nothing
Set varXlWB = Nothing
Set varxlApp = Nothing
Set dbCurrent = Nothing
in my script.But when i try to get the second excel sheets , i cant open it.The first excel itself remain opened .
Could anyone help me in getting this problem solved??????