
GioVit
Active Members-
Posts
134 -
Joined
-
Last visited
About GioVit
- Birthday 04/15/1962
Profile Information
-
Location
Venezuela
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
GioVit's Achievements

Adventurer (3/7)
0
Reputation
-
Sorry for late answer I would Like a function to edit array that can be integrated in a GUI window with other controls, don't need interactive width or height resize, nor formula calculation or range selection, but do need scrolling bar, Columns alignment definition and optional title on top and left that can be copied from top row and left Column from the same Array. I think it would be great UDF for those who need edit a database or large amount of data from an array, like me. Thanks in advance
-
Hi, martin very nice code, congratulation do you have plan to modify this UDF in order to edit array in a GUI, like GUICtrlCreateArray?
-
'm starting to use some function of the excel user defined functions, created by Locodarwin, and I notice that in the code there are many string using the format "R1C1" and also the code assume that the addres of a cell are returned with with the format "R" for "Row" and "C" for Column, and this is not true for non english excel. Specifically I'm using excel 2007 in spanish and the address is returned as "F1C1" where "F" and "C" represent Row and Column respectively. So I sugest the following modifications: 1.- Test the letter used to reference an address by regional or local excel every time an excel file is opened or created, as show below $HomeCell = $oExcel.WorkSheets(1).Cells(1,1) $HomeCellRef = $HomeCell.AddressLocal(True, True, $xlR1C1) $LocalRowRef = StringLeft($HomeCellRef,1) $LocalColRef = StringMid($HomeCellRef,3,1) 2.- Change all the reference of type "R1C1" to LocalRowRef & "1" & LocalColRef & "1" 3.- Change all the "R" and "C" to LocalRowRef and LocalColRef respectively Sorry for my English
-
Hi, I ran the _XMLExample.au3 on windows vista ultimate and I got an error on lin 199 (Variable must be of type Object) Is this a bug on the example file or it is some kind of incompatibility on Windows Vista OS? Thanks in advance
-
How can abort a shutdown process in vista and XP
GioVit replied to GioVit's topic in AutoIt General Help and Support
Sorry but "shutdown - a" seems that doesn't work. see code below #RequireAdmin HotKeySet("{ESC}", "_Quit") ; exit demo #include <File.au3> Global $logfile Global Const $WM_QUERYENDSESSION = 0x0011 Global $ShuttingDown = False If @Compiled Then ; log file location same as script $logfile = StringReplace(@AutoItExe, ".exe", ".log") Else ; for SciTe console testing only $logfile = StringReplace(@ScriptName, ".au3", ".log") Endif GUICreate("",1,1) ; dummy gui for shutdown message GUIRegisterMsg($WM_QUERYENDSESSION, "_ShutdownInitiated") Local $timer = TimerInit() While 1 if $ShuttingDown Then CancelShutDown() RunOtherPrograms() AskForShutDown() EndIf Sleep(100) ToolTip(Round(TimerDiff($timer))&" ms", @DesktopWidth /2 , @DesktopHeight /2, "Message Loop - 'ESC' to exit") WEnd Func _ShutdownInitiated($hWndGUI, $MsgID, $WParam, $LParam) ; windows message handler for WM_QUERYENDSESSION. ; For user logoff or system shutdown $ShuttingDown = True ;Beep(1000,5) _FileWriteLog($logfile, "Logoff or Shutdown Event - Exiting" & @CRLF) Return False ; acknowledges system shutdown command, responds to system with 'True' EndFunc ;==>_ShutdownInitiated Func _Quit() Exit EndFunc Func CancelShutDown() Run(@ComSpec & " /c Shutdown -a") EndFunc Func RunOtherPrograms() MsgBox(64,"Running", "Here is where you execute others programs") EndFunc Func AskForShutDown() $Result = MsgBox(35, "Pregunta", "Are you sure want to exit?", 15) if $Result = 6 or $Result = -1 Then ; Yes Shutdown Shutdown(1) Exit ElseIf $Result = 2 then ; Cancel Stop this program Exit EndIf EndFunc Any other solution? Thanks in advance -
How can abort a shutdown process in vista and XP
GioVit replied to GioVit's topic in AutoIt General Help and Support
...Thanks! , that's what a call a very fast and efective answer -
Can someone please explain me if there is a way to tell windows that stop shutdown process, so I can run another program (backup and Sync) and when finished then tell windows to shutdown normally. I know you can do a program in autoit that can execute and wait until the program finish an then it can shutdown the PC. But some times there are other peoples that use the PC an they don't know or they forgot to execute the porgram and the Backup and syncronization can't be executed. I also know that you can register WM_QUERYENDSESSION message but when return false from the function registered In windows vista appears a black screen asking if you want to kill the program. So this didn't tell to stop shutdown at all. Thanks in advance.
-
Some times, there are questions in General Help and Support, that have an excelent solution or answer (normally a very nice snippet) that deserves five stars like the stars you vote in Example Scripts section. I suggest to implement a star system voting for those creative answers or solutions, for the people that like to collect snippets and some times don't reads all the posts on the General Help and Support Section. Sorry about my English and and change Topic of discussion.
-
I just want to capture the arrows keys so I can emulate a grid control with many input controls arranged as a grid
-
First of all Happy new year to all the autoit comunity I ran the sample of subclassing an edit box from picasso DllCallBack() function, and that is what I need to capture some keys from an input or edit box (like up, down, left and right keys). So the question is how can I translate this program with the new autoit functions (DllCallbackFree, DllCallbackGetPtr and DllCallbackRegister). I'm really novice in callback and subclassing and don't know how to translate the subclassing sample. Thanks in advance
-
Capture arrow keys in GUI as an event
GioVit replied to GioVit's topic in AutoIt GUI Help and Support
Many Thanks I'll try it. -
I'm trying to make a kind of masking input control and I want to know if I can detect when an arrow key is pressed inside an input box. I know that I can use HotKeySet Function but I want to know if I can handle it Locally in the GUI Form as an event. Thanks in advance
-
Wow!!! Again, that was a really fast answer Gary many thanks I was trying to find the answer in google and thought it was impossible. it is incredible the things you can learn in this forum