AutoHotkey Community

Xeo786

I do not why earth.nullschool.net disable flat Azimuthal Equidistant projection of earth. :shh: https://user-images.githubusercontent.com/660529/43685006-f3335862-985f-11e8-8df0-ceab3fca7cfe.png to get map follow link ... https://github.com/systemsplanet/earth-ae for news... https://www.reddit.com/r...

Xeo786

you use AHK function regread ; RegRead, OutputVar, KeyName [, ValueName] RegRead, OutputVar1, HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings, ProxyServer, RegRead, OutputVar2, HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings, Proxyenable, MsgBox, Proxy Server: %Outp...

Xeo786

try this `rngGroup.cells(1).Group.Periods := Array(False, False, False, False, True, False, True)` if you get error again share your excel template having vb code

Xeo786

I also had issues while translating vba into ahk com but try this, ;~ expression. Group( _Start_ , _End_ , _By_ , _Periods_ ) rngGroup.cells(1).Group(,,,MyArray) all 4 fields in group(f1,f2,f3,f4) are option so left them as they are so they act as default, and i think you know what you were doing wr...

Xeo786

I'm wanting to use headers because the columns can change at a whim from users that access this spreadsheet are you talking about Name Ranges, assigning names? if so then following might help oExcel := ComObjCreate("Excel.Application") oExcel.Visible := True oWorkbook := oExcel.Workbooks.Add oExcel...

Xeo786

why R1C1 when you have .offset... i have some checking task so I paste few specific column that's an other excel com script but following is simply code well.. like if you selected A:A It will not compare A1 to B:B, it will compare A1 to B1 then A2 and B2 and so on ... :trollface: do not select whol...

Xeo786

Some success with border colors and named style: I do not use EPPlus but your sharing is useful for excel COM, I like to share my little function for excel borders and gonna make one for cell formatting too. XlApp := ComObjActive("Excel.Application") xlRange := XlApp.Worksheets(1).Range("a1:c13") x...

Xeo786

yah ClassName queryselector (many more) are not supported IE8 COM, sometime combo box has attribute like onchange that just do getelementsby("sometageORcombobox")[0].onchange() in case.

Xeo786

use ":=" when ever you work with COM

see Expression https://autohotkey.com/docs/commands/SetExpression.htm
and examples here http://www.daviddeley.com/autohotkey/xp ... amples.htm

Xeo786

the correct syntax is getElementsByClassName("some_class_name")[0] ..... (0) will through error

Code: Select all

wb.document.getElementsByClassName("advancedSearchField")[0].value = "UserID"

Xeo786

You can utilize clipboard as you said while search window freezes so "!a" would also not copy anything and clipboard remain empty, I would prefer using controlsend it would send key to specific window and you can do anything else but ^C copy :HeHe: ^v:: Send, !s ;searches for words in the app clipbo...

Xeo786

I has same issue, when web page simply waits when it through some pop up that needed to be filled before proceed, so sententiously AHK held until for COM code complete or through some error see my issue https://autohotkey.com/boards/viewtopic.php?f=5&t=20544 I used two script to accomplish that, mai...

Xeo786

I do not know JAVA that much but I was able to run your JS through ameyrick's ieCOM https://autohotkey.com/boards/viewtopic.php?f=6&t=19300 it worked for me.. and window.fromJs thing is beyond me :HeHe: ie := ComObjCreate("InternetExplorer.Application") ie.Navigate("about:blank") ie.Visible := true ...

Xeo786

Try running regsvr32 from cmd as Administrator! First I have uninstall registry then clean registry with cccleaner it get some com registry error which it deleted/cleaned after that I register dll with admin mode then I got com interface working.... Thanks you HotkeyIt ... I wana know how would tho...

Xeo786

Just tried it as admin still same error: 0x800401f3 - Invalid class string

Xeo786

I just want to utilize "AutoHotkey.dll" so I haven't replaced "AutoHotkey.exe" coz I doubt that my other work can have compatibility issue so I have registered only "AutoHotkey.dll" by running regsvr32 "D:\dll\AutoHotkey.dll" and registry gone successful ......... but following script not working ev...

Xeo786

below code Copy text to Excel's active cell then select next cell, f1:: send, ^C ; copy clipwait ; wait for data to get copied completely sometime it take time depend on data ComObjActive("Excel.Application").ActiveCell.value := clipboard ; data to excel active cell ComObjActive("Excel.Application")...

Xeo786

Select range in MS excel and it will compare the value of selection to right next column , and give answer in 3rd column to the right for cell in ComObjActive("Excel.Application").Selection if (cell.value > cell.offset(0,1).value) cell.offset(0,2).value := "OK" else cell.offset(0,2).value := "NOT OK"

Xeo786

predefined array EditList := ["Voornaam","Achternaam","Status","Geboortedatum","Geslacht","Adres","Postcode","Woonplaats","Toevoeging","Telefoonnummer","Mobielnummer","Emailadres","DatumInDienst","DatumUitDienst","Dienstverband","Uitzendnummer","Uren","Maandag","Dinsdag","Woensdag","Donderdag","Vrij...

Xeo786

use clipwait right after "^C"
https://autohotkey.com/docs/commands/ClipWait.htm

Search found 193 matches

Re: « What's on your mind? »

Re: fetch IE proxy port number? Topic is solved

Re: Grouping Excel Pivot Table by month and year

Re: Grouping Excel Pivot Table by month and year

Re: Seeking Advice on Best Approach for Email Handling with Attachments

Re: Seeking Advice on Best Approach for Email Handling with Attachments

Re: Help with EPPlus.dll and AHK Topic is solved

Re: IE COM Explorer 8

Re: Accessing Web Elements Topic is solved

Re: Accessing Web Elements Topic is solved

Re: Getting Ahk to notice when app performs a task finish. Topic is solved

Re: webscraping script is stopped -> popup Topic is solved

Re: Using eval and global JavaScript variables via InternetExplorer.Application

Re: AutoHotkey.dll and COM interface setup issue

Re: AutoHotkey.dll and COM interface setup issue

AutoHotkey.dll and COM interface setup issue

Re: Autocopy selected text and auto paste in EXCEL

Re: Need help: loop and compare number

Re: Display Array element in MsgBox Topic is solved

Re: Paste with delay?