snaileater

That's what i feared ... i'll check it with a newer Office version ... Thx for your answer.

I'm trying the Excel.udf, my starting point are the examples found in the help. My problem is that i can't find any working example of _Excel_RangeInsert ... made many tries but i can't find the reason why ... New/existing Worbook nothing changes ... i tried _Excel_RangeWrite without any problem, but with _Excel_RangeInsert i always get an @error=3 and @extended=-2147352562 ... What could i be missing ? Here's the minimalistic snippet i'm playing with : Local $sWorkbook = @ScriptDir & "\pixel.xls" Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook) If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel ...", "Error opening '" & $sWorkbook & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended) $dummy=_Excel_RangeInsert($oWorkbook.Activesheet, "1:3") If @error Then    $a=@extended    MsgBox($MB_SYSTEMMODAL, "Excel ...", "Error inserting" & @CRLF & "@error = " & @error & ", @extended = " & @extended) Else    MsgBox($MB_SYSTEMMODAL, "Excel ...", "Rows successfully inserted") EndIf ConsoleWrite ($dummy & chr(13) & $a & Chr(13)) I tried every possible (...) syntax for the range object, without success ... I use the latest releases of AutoIt and Office 97 ... Thanks for your help ...

Thanks for spending some time on my question Reb but your code is not doing what i would like : Your code allow the user to go out the "restricted area" and then check whether the moved window respect the x,y limitations. What i would like is a way to force the x,y limitations during the move ...

That's not my question ...

Hi, i'm trying to limit the moves of a borderless GUI. i'm on an example taken from Moving and Resizing PopUp GUIs. I'm using the _SendMessage function so far : While 1 Switch GUIGetMsg() Case $GUI_EVENT_PRIMARYDOWN _SendMessage($hGUI, $WM_SYSCOMMAND, $SC_DRAGMOVE, 0) EndSwitch WendI would like to add some constrain on the X,Y coords of the window (for ex. forbid X exceeding 1000) ... How could i achieve that ? It Seems to me that i have to follow two events at the same time (EVENT_PRIMARYDOWN + EVENT_MOUSEMOVE) but i'm not sure to be on the right track ... Could anybody help me ? Thanks ...

Hi, excuse me the dumb question but : has anybody done a nice "Calendar - Scheduler - Planning - Timeline" interface that could be shared with the community (as example-starting point ) ? I would like to be able to create events/reminders in grids of such interface. Thanks !

Any idea ? ...

Hi, i'm doing some experiments with the Taskplaner/Taskscheduler COM UDF written by Allow2010 (>link)... Everything is running fine BUT when i try to get back in the Task Scheduler of Windows (seven) i often get an error message ("the mmc console has detected an errror" ... , can't easily translate the rest ...) Is there something i should do before leaving my AutoIt Scripts ? (dunno, something like ... "destroying" some objects ? deconnecting from the Schedule.Service ?) Thanks for your help !

Nice, working well, easy to use ... a ModifyTask() function would have been nice though (but it is easy to write ...) Thanks !

Hi, i would like to automate an external Qt-based application with AutoIt. I use AutoIt Window Info to retrieve some information about this application but it looks like the utility is returning (almost) no information (main window of the external application is of "QWidget" class). Is it a behaviour i should have expected ? Could it be any workaround ? thanks for help !

Hi, i would like to achieve a quite "easy" task : automating notepad++ to open a file and lead the user to a given line of the file by doing a given string search (let's say seeking "mod.xxxx" to find modification n°xxxx in a source code ...) I intend to do this automation by using senkeys commands to notepad++ (unless there's a smarter way to do that ... ?) Is there a way to get the list of the curently opened files in a notepad++ session ? if the desired file is already opened in notepad++ i would like to be able to activate the corresponding tab and then do the string search described above. Thanks for help !

Hello, i would like to write a small PIM (Personal Information Manager) application using autoit. First of all i would like to use a timeline-based representation of stored events, notes or reminders. Has anybody already tried to create such kind of graphical interface using Autoit ? Thanks !

Hello, i would like to write a small PIM (Personal Information Manager) application using autoit. First of all i would like to use a timeline-based representation of stored events, notes or reminders. Has anybody already tried to create such kind of graphical interface using Autoit ? Thanks !

That's the one i use ... i just meant "not the on-line version" ... The topic can be closed ... next time i should have a deeper look in the doc (i just didn' read the inetget info "Alex") ... At least my topic title was right ... it was a dumb question ... is there a way to tag the topic as "closed" ? thanks guys !

hum ? I don't see that in the help file i have here (offline version) which i downloaded a few days ago ... Thanks