Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Closing a specific Excel file
#2
Solved: 10 Years, 10 Months, 1 Week ago
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
Reply


Messages In This Thread
Closing a specific Excel file - by mv8167 - 08-19-2011, 02:09 AM
RE: Closing a specific Excel file - by sshukla12 - 08-19-2011, 11:34 AM
RE: Closing a specific Excel file - by mv8167 - 08-19-2011, 08:33 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to export the output value of a webedit object to a new excel file. mounika6677 1 1,358 04-14-2019, 05:18 PM
Last Post: mounika6677
  Access not saved excel file randhirsinghskhn 0 945 09-04-2018, 07:26 AM
Last Post: randhirsinghskhn
Question How to open IE/Chrome/Firefox with a specific size? DarkestAmadeus 0 1,945 07-19-2018, 05:38 AM
Last Post: DarkestAmadeus
  dtLocalSheet empty even though excel file contains data cantorre 2 2,270 05-10-2017, 12:47 PM
Last Post: vidhi
  SAP GUI gets hanged while closing the Windows Pop Up kathirvelnagaraj 0 5,352 10-23-2015, 06:47 PM
Last Post: kathirvelnagaraj

Forum Jump:


Users browsing this thread: 1 Guest(s)