Closing a specific Excel file

[mv8167]

Is there a easy way to close a specific Excel file? I can close all of them, I just cant seem to close one file.

thx everyone ;-)

[sshukla12]

Try this:

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

[mv8167]

Sankalp.

Thx, I guess In was just tired. Was up since 1:30am with a Prod issue. Thx, i am clear now.

Lor