Excel UDF Question

[Kaimberex]

I am having some difficulties figuring out why when using the _Excel_BookClose function if I have an Excel sheet already opened that was not opened with _Excel_BookOpen it still closes the workbook. 

 

Here is a snippet of some of my code. Any guidance is appreciated!

 

$ConfigFileCheckPrinterSelection = IniRead($ConfigFile, "Printers", "Selected Printer", "Microsoft XPS Document Writer")
            $oExcelChecklist = _Excel_Open(False)
            If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error", "Error starting Excel." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
            $sFilePathChecklist = @ScriptDir & "\Documents\New Hire Checklist.xlsx"
            $workbookChecklist = _Excel_BookOpen($oExcelChecklist, $sFilePathChecklist)
            If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error", "Error opening to workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
            _Excel_Print($oExcelChecklist, $workbookChecklist.Activesheet, Default, $ConfigFileCheckPrinterSelection, Default, Default, Default, Default, Default)
            If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Printing Error", "Error printing worksheet." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
            MsgBox($MB_SYSTEMMODAL, "Print Success", "New Hire Checklist successfully printed.")
            $oExcelQuickGuide = _Excel_Open(False)
            If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error", "Error starting Excel." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
            $sFilePathQuickGuide = @ScriptDir & "\Documents\New Hire Quick Guide.xlsx"
            $workbookQuickGuide = _Excel_BookOpen($oExcelQuickGuide, $sFilePathQuickGuide)
            If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error", "Error opening to workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
            _Excel_Print($oExcelQuickGuide, $workbookQuickGuide.Activesheet, Default, $ConfigFileCheckPrinterSelection, Default, Default, Default, Default, Default)
            If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Printing Error", "Error printing worksheet." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
            MsgBox($MB_SYSTEMMODAL, "Print Success", "New Hire Quick Guide successfully printed.")
            _Excel_BookClose($workbookChecklist, False)
            _Excel_BookClose($workbookQuickGuide, False)

I do not receive any errors. Just any excel workbooks I had open before this particular function runs gets closed after the documents print. 

Edited October 26, 2016 by Kaimberex

[Joboy2k]

$Excel = _Excel_Open(True, Default, True, Default, True)

im not 100% sure if this is correct but the last true on the line forces and new instance of Excel rather than using an already open one. try it and see.

Edited October 26, 2016 by joboy2k
spelling mistake

[water]

It's correct