Excel not closing after vbscript finish looking for Data value

Pascal Lacasse

• May 29, 2023 15:35

Hello,

Need some help please, excel app stay open after being run.

Thank You!

 

WHAT_TO_FIND = Format.NamedSubStrings("Lot#").Value

File_Path = "C:\BarTender\TableList.xlsx"

Set oExcel = CreateObject("Excel.Application")
Set oData = oExcel.Workbooks.Open(File_Path)
Set FoundCell = oData.Worksheets("info").Range("A2:A1500").Find(WHAT_TO_FIND)
row = FoundCell.Row
col = FoundCell.Column

Value = oData.Worksheets("info").Cells(row,col+10)

oExcel.Quit

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • May 30, 2023 07:55

  Is there any reason you are using VB and not creating a Database Connection to achieve this?

  My guess would be that Excel is doing the usual and asking if you want to save it or not when you try to close it and so may need to include something in your script for this.

  0
• 

  Pascal Lacasse

  ★ BarTender Hero ★

  • May 30, 2023 18:03

  DB is already been used to grab other data.

  I try out different way, save and close. Still not working.

  Set FoundCell = Nothing
  oData.Close False
  Set oData = Nothing
  oExcel.Quit 
  Set oExcel = Nothing

  For now, after script is executed, we kill Excel in task manager using VBScript.

   

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • May 31, 2023 08:34

  Not sure if this helps, going back to the old Quit command

  https://stackoverflow.com/questions/20979154/how-to-close-excel-file-from-vbscript-without-being-prompted

  0

Please sign in to leave a comment.