Custom Query

3.3.7.21(beta) 3.3.6.1

Any reference to $oExcel.ActiveWorkbook.Sheets.Count after creating the Excel object with _ExcelBookAttach() seems to error. These are the five functions with that reference:

_ExcelBookOpen _ExcelSheetDelete _ExcelSheetList _ExcelSheetActivate _ExcelSheetMove

And this is the error:

C:\Program Files\AutoIt3\Include\Excel.au3 (1063) : ==> The requested action with this object has failed.:
Local $iTemp = $oExcel.ActiveWorkbook.Sheets.Count
Local $iTemp = $oExcel.ActiveWorkbook^ ERROR

References to $oExcel.ActiveWorkbook.Sheets() work fine. It's the ones without parenthesis that break. They also all work fine if the object is created with _ExcelBookOpen() instead of _ExcelBookAttach().

I compiled my script for an experiment when i encountered this error on console window of Scite

'ResHacker.exe' is not recognized as an internal or external command, operable program or batch file.

with an autoitwrapper code of

#AutoIt3Wrapper_Run_After=ResHacker.exe -add %out%, %out%, image3.jpg, rcdata, TEST_JPG_3, 0

but it turned OK when I used

#AutoIt3Wrapper_Run_After=Start ResHacker.exe -add %out%, %out%, image3.jpg, rcdata, TEST_JPG_3, 0

I think AutoitWrapper must somehow change it's way of handling running after/before events because it uses

Run(@ComSpec & ' /C ' & $INP_Run_After[$x] & '', '', @SW_HIDE, $STDERR_CHILD + $STDOUT_CHILD)

in running other programs which can produce errors

In working with _ClipBoard_GetData() and looking at the code (in Clipboard.au3), I've noticed some major flaws with it (AutoIT version 3.3.0.0):

1. Unicode text will not be returned (at all)
2. An arbitrary limit is placed on the ANSI/OEM text to be returned (8192 chars)
3. The Clipboard is closed before the data is transferred. (From the source code I've reviewed, this is not good form)
4. The Global memory isn't locked for anything but ANSI/OEM text
5. Returning any other data types then the 3 it handles will result in a Global memory handle being returned (*not* locked)

With my code, I went ahead and fixed all of the above, and used the _MemMoveMemory() function to transfer memory to an AutoIT structure for only the 'unknown' data types. (The rest can be obtained quite easily).

Also: one enhancement: The size of the data is returned in @extended, and is in chars for CF_TEXT, CF_OEMTEXT, and CF_UNICODETEXT, or in bytes for any other data type.

I don't know the method for submitting the fixed code or extra documentation (regarding @extended), so please let me know what else I should do.

Fixed code is attached.