Custom Query (3910 matches)

_ExcelBookOpen will run into an error, if the first sheet of the workbook is hidden. If you try to select it, the COM interface throws an error.

It can be fixed by testing, if the sheet is visible Out:

.ActiveWorkbook.Sheets(1).Select ()

In:

For $xx = 1 To .ActiveWorkbook.Sheets.Count
	If .ActiveWorkbook.Sheets($xx).Visible == $xlSheetVisible Then
		.ActiveWorkbook.Sheets($xx).Select ()
		ExitLoop
	EndIf 
Next

And some additional constants are needed

Const $xlSheetHidden = 0
Const $xlSheetVisible = 1
Const $xlSheetVeryHidden = 2

Greetings frubi

Hi,

The problem is that when we set attributes using recursive mode, and one of the files are missing in some subfolder, then FileSetAttrib does not continue to next files, it's just stops and return 0.

If Not FileSetAttrib(@ScriptDir & "\Test\test.txt", "+H", 1) Then
	MsgBox(4096, "Error", "Problem setting attributes.")
EndIf

Folders/files structure:

.\Test\test.txt
.\Test\Subfolder
.\Test\Subfolder\Subfolder\Test.txt

Now here for the last file «Test\Subfolder\Subfolder\Test.txt» the attributes are not set.

While the console attrib.exe program does not stops, it's set attributes for all the files it can (it skips the problematic files).

If it's not a bug and it's designed like that (why?), then i think at least this should be mentioned in the help file.

Thanks.

The return values are interchanged in

_GUICtrlComboBoxEx_GetCurSel _GUICtrlComboBoxEx_SetCurSel