08-19-2011, 11:34 AM
Try this:
Correct me if wrong.
Regards,
Sankalp
Code:
Set excel=CreateObject("Excel.Application")
excel.visible=true
set obj_excel=excel.workbook.open(<Enter the path for ur excel file>)
like this u can open many excel files but use the reference to close any particular file.
obj_excel.close()
Correct me if wrong.
Regards,
Sankalp