
rajeshontheweb
Active Members-
Posts
377 -
Joined
-
Last visited
Everything posted by rajeshontheweb
-
May be too late a reply, but i am on the same search, try this http://stackoverflow.com/questions/9737354/how-to-write-to-a-google-spreadsheet-from-excel-2003-vba
- 3 replies
-
- Google Drive
- Spreadsheet
-
(and 1 more)
Tagged with:
-
AutoIt Error - Unable to open the script file.
rajeshontheweb replied to mdwerne's topic in AutoIt General Help and Support
an update to all who might have incurred the same problem. i have been seeing this error with one of my office PCs which is infected with Sality.M. Sality variants meddle with most of C++ based software i have trouble opening any au3 script be it from scite or as a compiled exe - it doesnt run, also voidtools.com's everything software , xsearch software also dont work... -
UUID from Win32_ComputerSystemProduct
rajeshontheweb replied to rajeshontheweb's topic in AutoIt General Help and Support
guys, its been a while and i would think i should close saying the WMI info is to be just formatted properly to get the widely accepted UUID value. i havent understood why WMI would give me some value and other software actually interpret the same little differently. i would post the updated code if i get a universal formatting pattern. -
Now available on Softpedia! (since a few months now, but i have been too busy to attend to myself ) Will resume my work shortly. sorry for being away so long..
-
New SciTE4AutoIt3 available with SciTE v1.79
rajeshontheweb replied to Jos's topic in AutoIt Technical Discussion
Was just wondering if there is any news in the direction. Your work with this is an extremely useful contribution i would thank u again. There's just some bugfixes / improvements in scite v2 and i am sure you would be able to decide if its gonna be worthy for us. -
New SciTE4AutoIt3 available with SciTE v1.79
rajeshontheweb replied to Jos's topic in AutoIt Technical Discussion
Scite 2.03 released! -
u might want to use vbscript object more information here & here
-
when u look at the bottom pane, the output status is shown (view > Output) which will detail the target file's location (by default it is the same folder as the source au3 file..)
-
have u got it submitted in the add on page? https://addons.mozilla.org/en-US/developers/addon/submit
-
you can use the registry [HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Restrictions] "NoBrowserOptions"=dword:00000000which is to be coded as RegWrite("HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Restrictions", "NoBrowserOptions", "REG_DWORD", "00000000")change the value to "00000001" to disable the remove the restriction.. to extend it further, check if the process iexplore.exe is running and notify user if it is running / kill the process using the code. because it better be reloaded after u alter the registry values... <edit> this is available readily in various sources in the internet like this Enable Internet Options Disable Internet Options of course scripting would allow u to extend it much further by checking if IE is running , etc
-
Getting Windows Context Menu Items
rajeshontheweb replied to QingZi's topic in AutoIt General Help and Support
god i lost something valuable, i had a routine which collects all the right click menu verbs / items i will find out and get back here... -
its nice, but one suggestion, i would like the use of $val = Run("explorer.exe /e ," & $objEvent.TargetInstance.DeviceId ) rather than open verb because in many a case, if the autorun virus has already infected the pc, then u would end up with this.
-
Check Windows Genuine Validation
rajeshontheweb replied to dbzfanatic's topic in AutoIt General Help and Support
just being curious, i have an understanding that few pirated copies of windows look like they have been activated (i used to think that may be these pirates would drop a reg key to disable the prompt to activate the windows) in this case, WGA wont be checked with checking only the registry key isnt it. specially finding out if windows copy is genuine would require checking up visiting http://www.microsoft.com/genuine/validate/?displaylang=en&sGuid=490b5bb4-b1f1-4adc-9da2-69bdac622b05 using IE or using the WGA plugin in case of other browsers. pls correct me if this tool still just looks up the corresponding reg key or it does more ! -
1) yeah i did use that, thats why i had mentioned earlier that it would have been better to monitor it live - but i noticed it is already available. i just didnt realise that while download is active, live monitoring of clipboard is disabled and i did use the option to import from clipboard. one thing i didnt mention was that rapidshare.de links were not available for import from clipboard this could be intentional as language barriers might have made it harder to code it - so i didnt mention it. 2) point taken, it was just my opinion.. 3) point taken, yet my request was not focused on time taken but links list being made available. because the link is deleted from the list and in case i wanted to keep the links for future use --- which i did a couple of items i wanted i have saved them in a text file for future use. if i am to rephrase my feature request it would be ' a log file to log files that have been downloaded (after it is removed from active links list, would be welcome' Anyways, no logs doesnt bother really. 4) this point came to my mind first time i went to the d/l folder from the tray menu - i saw 4 files in download list, when i opened one of them it was not complete but yet the file was shown available in explorer, i still couldnt use it and then realised that the file size was smaller and when i checked it said it is 80% only complete.(pretty dumb fault , i know) and once i had forced a PC reboot while RQ was active and the link list was lost for unknown reason (which may or may not relate to RQ - i was unsure) thanks a lot for taking time to explain it all. keep up the good work..
-
New SciTE4AutoIt3 available with SciTE v1.79
rajeshontheweb replied to Jos's topic in AutoIt Technical Discussion
do we have the 3.3.2 keywords support completed yet? thanks for the great job again.. -
not that i may even use it ever again but having used it once, i felt a few things that might be useful clipboard monitoring - yes its there already, only i didnt realise it is paused when download is in progress and more, i would like to see a gui built around .. rather than just a progress bar only. there better be a log file (of course optional) which would write all links used so far with start and finish times. most important, till download is finished, we better add .tmp or .rq to the file extension just to identify its an incomplete file. ie, now we have xxyy.txt being downloaded which is 20 MB and there was a power failure / internet disruption, i wont be able to recognise if the 10 MB file downloaded is correct or not!
-
here is my situation i have an object (actually wmi object) Func TestFunction($Parameter) Dim $wbemFlagReturnImmediately = 0x10 Dim $wbemFlagForwardOnly = 0x20 Dim $colItems = "" Dim $strComputer = "localhost" Dim $retVal = 0 $objWMIService = ObjGet("winmgmts:\\" & $strComputer & "\root\CIMV2") $colItems = $objWMIService.ExecQuery("SELECT * FROM win32_computersystemproduct", "WQL", $wbemFlagReturnImmediately + $wbemFlagForwardOnly) If IsObj($colItems) Then For $objItem In $colItems $retVal = "Caption: " & $objItem.UUID ; <<<<<<<<<<<<<<<<<<<<<<<<<<------------------ Next EndIf Return $retVal EndFunc ;==>TestFunction ConsoleWrite(@CRLF & TestFunction("UUID") & @CRLF) Now, In place of calling TestFunction("UUID") if i say "Name" it should execute the line as $objItem.Name i.e., TestFunction("UUID") <--> $retVal = "Caption: " & $objItem.UUID TestFunction("Name") <--> $retVal = "Caption: " & $objItem.Name
-
can you add further clipboard monitoring, just like flashget, fdm, etc do? http://www.autoitscript.com/forum/index.php?showtopic=56158&st=0&p=426033&#entry426033 has it all. and also, when we click on add from clipboard, if there is any rs links available, it takes it. but badly formatted rs links or unavailable rs links are not notified.
-
shutdown function replacement
rajeshontheweb replied to Qball's topic in AutoIt General Help and Support
follow innovative's example just go through command prompt shutdown /? help info to see what are the options u have for shutdown / force shutdown / restart , etc if u want native autoit command for shutdown, use Shutdown(code) 1 shutdown 2 reboot this is straight from help file.. -
USB Device detection (Media Device)
rajeshontheweb replied to SH1NS0U's topic in AutoIt General Help and Support
also, if u browse through the forums, u will find there is a piece of code which does the same thing using Windows API Calls too.. -
USB Device detection (Media Device)
rajeshontheweb replied to SH1NS0U's topic in AutoIt General Help and Support
try this its from the same link but just abit of modification to make it clear of what u need to use thats all... #include <WindowsConstants.au3> $strComputer = "." $objWMIServices = ObjGet("winmgmts:" & "{impersonationLevel=impersonate}!\\" & $strComputer & "\root\cimv2") $sink = ObjCreate("WbemScripting.SWbemSink") ObjEvent($sink,"SINK_") $objWMIServices.ExecNotificationQueryAsync ($sink, "SELECT * FROM __InstanceOperationEvent WITHIN 5 WHERE " & "TargetInstance ISA 'Win32_LogicalDisk'") While 1 Wend Func SINK_OnObjectReady($objObject, $objAsyncContext) If $objObject.TargetInstance.DriveType = 2 Then Select Case $objObject.Path_.Class()="__InstanceCreationEvent" Consolewrite("Drive " & $objObject.TargetInstance.DeviceId & " has been added." & @CR) Case $objObject.Path_.Class()="__InstanceDeletionEvent" ConsoleWrite("Drive " & $objObject.TargetInstance.DeviceId & " has been removed."& @CR) EndSelect EndIf EndFunc -
you would find a few articles based on whether it should have been 7 or why is it win 7... for that matter, windows 2000 to windows 7 - all are still called Win32_NT !!!! built around Windows NT ?
-
unique ID for System(PC)
rajeshontheweb replied to Digisoul's topic in AutoIt General Help and Support
This might help if u are good at C++ -
Use WMI Query Win32_Printer Class read the attributes and look for all those with attribute 16 (Network Printers) {64 if u need local Printers}Populate them to an array and use it as source for your list box.There is a possibility AddPrinterConnection Method may work (try it out)