Search found 192 matches

Go to advanced search

by Xeo786
15 Jan 2019, 01:52
Forum: Ask For Help
Topic: fetch IE proxy port number? Topic is solved
Replies: 2
Views: 108

Re: fetch IE proxy port number? Topic is solved

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...
by Xeo786
14 Jan 2019, 07:13
Forum: Ask For Help
Topic: Grouping Excel Pivot Table by month and year
Replies: 7
Views: 235

Re: Grouping Excel Pivot Table by month and year

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
by Xeo786
14 Jan 2019, 05:21
Forum: Ask For Help
Topic: Grouping Excel Pivot Table by month and year
Replies: 7
Views: 235

Re: Grouping Excel Pivot Table by month and year

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...
by Xeo786
17 Jul 2018, 03:23
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 22
Views: 1084

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

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...
by Xeo786
16 Jul 2018, 01:33
Forum: Ask For Help
Topic: Seeking Advice on Best Approach for Email Handling with Attachments
Replies: 22
Views: 1084

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

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...
by Xeo786
27 Jun 2018, 03:33
Forum: Ask For Help
Topic: Help with EPPlus.dll and AHK Topic is solved
Replies: 39
Views: 1720

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

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...
by Xeo786
26 Jun 2018, 04:21
Forum: Ask For Help
Topic: IE COM Explorer 8
Replies: 1
Views: 96

Re: IE COM Explorer 8

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.
by Xeo786
26 May 2018, 00:39
Forum: Ask For Help
Topic: Accessing Web Elements Topic is solved
Replies: 5
Views: 332

Re: Accessing Web Elements Topic is solved

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
by Xeo786
25 May 2018, 01:02
Forum: Ask For Help
Topic: Accessing Web Elements Topic is solved
Replies: 5
Views: 332

Re: Accessing Web Elements Topic is solved

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

Code: Select all

wb.document.getElementsByClassName("advancedSearchField")[0].value = "UserID"
by Xeo786
25 May 2018, 00:35
Forum: Ask For Help
Topic: Getting Ahk to notice when app performs a task finish. Topic is solved
Replies: 8
Views: 397

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

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...
by Xeo786
16 May 2018, 01:06
Forum: Ask For Help
Topic: webscraping script is stopped -> popup Topic is solved
Replies: 11
Views: 629

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

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...
by Xeo786
26 Apr 2018, 03:27
Forum: Ask For Help
Topic: Using eval and global JavaScript variables via InternetExplorer.Application
Replies: 2
Views: 279

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

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 ...
by Xeo786
22 Mar 2018, 03:35
Forum: Ask For Help
Topic: AutoHotkey.dll and COM interface setup issue
Replies: 3
Views: 795

Re: AutoHotkey.dll and COM interface setup issue

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...
by Xeo786
21 Mar 2018, 02:29
Forum: Ask For Help
Topic: AutoHotkey.dll and COM interface setup issue
Replies: 3
Views: 795

Re: AutoHotkey.dll and COM interface setup issue

Just tried it as admin still same error: 0x800401f3 - Invalid class string :headwall:
by Xeo786
20 Mar 2018, 06:49
Forum: Ask For Help
Topic: AutoHotkey.dll and COM interface setup issue
Replies: 3
Views: 795

AutoHotkey.dll and COM interface setup issue

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...
by Xeo786
01 Mar 2018, 03:13
Forum: Ask For Help
Topic: Autocopy selected text and auto paste in EXCEL
Replies: 5
Views: 497

Re: Autocopy selected text and auto paste in EXCEL

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")...
by Xeo786
01 Mar 2018, 02:55
Forum: Ask For Help
Topic: Need help: loop and compare number
Replies: 3
Views: 231

Re: Need help: loop and compare number

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"
by Xeo786
23 Feb 2018, 05:44
Forum: Ask For Help
Topic: Display Array element in MsgBox Topic is solved
Replies: 8
Views: 560

Re: Display Array element in MsgBox Topic is solved

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...
by Xeo786
14 Feb 2018, 05:10
Forum: Ask For Help
Topic: Paste with delay?
Replies: 1
Views: 174

Re: Paste with delay?

use clipwait right after "^C"
https://autohotkey.com/docs/commands/ClipWait.htm
by Xeo786
13 Feb 2018, 08:36
Forum: Ask For Help
Topic: how can i click this element? Topic is solved
Replies: 2
Views: 205

Re: how can i click this element? Topic is solved

try this one btn := pwb.document.getElementsByTagName("button") loop % btn.length if (btn[A_Index-1].getAttribute("onclick") = "saveData();") { btn[A_Index-1].click() break } OR btn := pwb.document.getElementsByTagName("button") btn_length := := pwb.document.getElementsByTagName("button").length loo...

Go to advanced search