Want to close excel files i.e. .XLSX files that are open from the particular folder. - (Moved)

[Preetam]

I was looking for some help on the other forums and saw that there is code available for closing all the excel files what are open and that works in closing every single excel file that is open. But I am not able to find anything if I want to close excel files from a particular folder.

I am exporting some reports from SAP and the excel files open automatically after export and I am trying to use AutoIT to close the open .xlsx files from the particular folder. If anyone has faced similar issue then please do help.

[Melba23]

Moved to the appropriate AutoIt General Help and Support forum, as the Developer General Discussion forum very clearly states:

Quote

General development and scripting discussions.

---

Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums.

Moderation Team

[Melba23]

Preetam,

Please stick to just the one thread per topic - I have deleted all the others.

M23

[robertocm]

Perhaps using this funcion to detect open excel files in the folder, and then closing them passing their paths to the Excel UDF:

_WinAPI_FileInUse

This could give some ideas:

#include <File.au3>
#include <WinAPIFiles.au3>

Global $aFileList, $bFileOpen
Global $sFolder = FileSelectFolder("Directory", "")
;Global $sFolder = FileSelectFolder("Select root folder", @ScriptDir, 0, @ScriptDir)
Global $sFolderLen = StringLen($sFolder)
If StringRight($sFolder, 1) = "\" Then $sFolderLen += 1

$aFileList = _FileListToArray($sFolder, "*.xls", 1, True)
If Not @error Then
    For $i = 1 To $aFileList[0]
        ;Discard some kind of temp files (locked files from antivirus?)
        If StringInStr($aFileList[$i], "~", 0, 1, $sFolderLen) > 0 Then
            Consolewrite($aFileList[$i] & @CRLF)
            ;FileDelete($aFileList[$i])
            ContinueLoop
        EndIf

        $bFileOpen = _WinAPI_FileInUse($aFileList[$i])
        If $bFileOpen = 0 Then
            Consolewrite($aFileList[$i] & @CRLF)
        Else
            Consolewrite("Locked file: " & $aFileList[$i] & @CRLF)
        EndIf
    Next
Else
    MsgBox(16, "Error", "No excel files were found in the folder")
EndIf

[Andreik]

I think you don't even have to use _WinAPI_FileInUse(). Get the list of excel files from desired directory as in @robertocm 's example and then in a loop use _Excel_BookAttach() for each file. If the function does not fail it means the file it's open and the function will return the Excel workbook object that can be easily be passed to _Excel_BookClose().

[water]

Use _Excel_BookList to get a list of open workbooks. The returned array holds the full path of each workbook.