H1T1

Hi Andy, I tried but it is not that easy for most users.. It would be make the change in library. Thanks

In another forum, I was requesting way to create UserDefinedFunction in SQLite. I was hoping to find a way to create autoit functions and call them within SQLite part of SQL. With my limited knowledge, I was only able to get this functionality by using the "load_extension" in SQLite and calling functions written in C Language. This is how I did it: Due to SQLite security, this function is turn off so to activate, I had to modify the SQLite.au3 library. I added the following statement to the "_SQLite_Open" function ======================= Func _SQLite_Open($sDatabase_Filename = Default, $iAccessMode = Default, $iEncoding = Default) . . . . $aaa=dllcall($g_hDll_SQLite,"int:cdecl","sqlite3_enable_load_extension","ptr",SetExtended($avRval[0], $avRval[2]),"int",1) Return SetExtended($avRval[0], $avRval[2]) EndFunc ;==>_SQLite_Open ======================= Once this done, I downloaded an existing library that adds multiple functions from: http://www.sqlite.org/contrib : the file is called "extension-functions.c". after downloading "extension-functions.c", I compiled it using MinGW as explained in the file and create a library called "extension-functions.so". I have attached the modified SQLite.au3 library, the compiled SQLite library and also an example. IT would be nice for an expert with Autoit to see if a function written in C would allow to call autoit functions. One last favor, to the owner for the SQLite.au3 library... Please add the change above to the library so that I do not need to do it manually everytime is updated. References: http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions http://www.mingw.org/wiki/HOWTO_Install_the_MinGW_GCC_Compiler_Suite http://www.sqlite.org/contrib Example.zip

PsaltyDSm, you got it right. I was only hoping that this would have worked. Thanks Any way

I have been looking at the same think and tough it was not possible until I installed :SQLite Manager on Firefox and saw that user-defined function can be created... I hope there would be away to do this with Autoit.

here is an example that works. Creates a new workbook, adss data in sheet1, renames the tab and saves it. $oExcelapp =ObjCreate("Excel.Application") $oExcel=$oExcelapp.workbooks.add $oExcel.sheets(1).cells(1,1).Formula="Sheet Name" $oExcel.sheets(1).name="sddsd" FileDelete("c:\test.xlsx") $oExcel.saveas("c:\test.xlsx") $oExcel.close (false) $oExcel=0 $oExcelapp=0

I would like some help as I have not been able to find a way to identify all the windows related to a running process. For example, when i use Outlook, I often have over 30 emails open. I would like to write a program to close all windows related to outlook except the main page.