Search found 70 matches

by inseption86
30 Jul 2019, 08:53
Forum: Ask For Help
Topic: Сell comparison in Excel Topic is solved
Replies: 1
Views: 123

Сell comparison in Excel Topic is solved

Hello guys, tell me how to compare several lines, I can do one line (there are 10 columns), and how to make a cycle, for example, into 5 lines

Code: Select all

loop 10
{
IF xl.workSheets(1).cells(1,A_Index).value != xl.workSheets(2).cells(1,A_Index).value 
{
MsgBox, 4144, , % xl.cells(1,A_Index).value
}
}
by inseption86
09 Jul 2019, 05:39
Forum: Ask For Help
Topic: Search folder
Replies: 3
Views: 292

Re: Search folder

Is not working, this is my code #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. #SingleInstance force...
by inseption86
02 Jul 2019, 10:09
Forum: Ask For Help
Topic: Search folder
Replies: 3
Views: 292

Search folder

Hi guys, tell me please There are folders with files, how to find out the name of the folder, if, for example, the file with the name "* hello *" in this folder is missing? Thank you in advance This is code not working! FormatTime, TimeString, , dd.MM.yyyy Folder := % "C:\Document\" TimeString Loop,...
by inseption86
07 Apr 2019, 09:14
Forum: Ask For Help
Topic: How to get and set values in a web-page using API Calls? Please help.
Replies: 4
Views: 355

Re: How to get and set values in a web-page using API Calls? Please help.

driver := ComObjCreate("Selenium.ChromeDriver") driver.AddArgument("--disable-infobars") driver.Get("https://www.autohotkey.com/boards/viewtopic.php?f=76&t=63439&p=271535&hilit=selenium#p271535") driver.findElementsById("keywords").item[1].SendKeys("hello") Esc::ExitApp Exit: driver.Quit() ExitApp
by inseption86
07 Apr 2019, 09:07
Forum: Tutorials
Topic: Using Selenium with AutoHotkey- Cross browser automation!
Replies: 98
Views: 36826

Re: Using Selenium with AutoHotkey- Cross browser automation!

Please help... driver := ComObjCreate("Selenium.ChromeDriver") driver.AddArgument("--disable-infobars") driver.AddArgument("--start-maximized") driver.Get("https://www.google.com") driver.ExecuteScript("window.open();") driver.SwitchToNextWindow driver.Get("https://yandex.ru") w:: ;"https://www.goog...
by inseption86
02 Apr 2019, 10:01
Forum: Ask For Help
Topic: AHK: Chrome_selenium
Replies: 0
Views: 173

AHK: Chrome_selenium

Hi guys, to work with a new tab, I get the object associated with it by url ie := ComObjCreate("InternetExplorer.Application") ie.Visible := true ie.Navigate("https://www.google.com") ie.Navigate("https://www.autohotkey.com",2048) q:: ie := WBFromUrl(""https://www.google.com") return w:: ie2 := WBFr...
by inseption86
02 Apr 2019, 06:13
Forum: Ask For Help
Topic: AHK: Chrome_selenium
Replies: 1
Views: 211

Re: AHK: Chrome_selenium

"SeleniumBasic-2.0.9.0.exe" /VERYSILENT /SUPPRESSMSGBOXES /NORESTART /SP-

select only the first position when installing ?

Image
by inseption86
01 Apr 2019, 15:01
Forum: Ask For Help
Topic: AHK: Chrome_selenium
Replies: 1
Views: 211

AHK: Chrome_selenium

Hello guys, tell me please, there are a lot of questions: 1. is it possible to somehow automate captcha input - #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. #SingleInsta...
by inseption86
03 Mar 2019, 10:47
Forum: Ask For Help
Topic: AHK: FileExist Topic is solved
Replies: 2
Views: 255

AHK: FileExist Topic is solved

Hi guys, is it possible to make the check on all "xlsx", except for files with the existing "........ yes ..... xlsx"

Code: Select all

If FileExist(A_Desktop "\*.xlsx") 
   {
TrayTip,, !!!!
sleep 2000
} 
return
by inseption86
25 Feb 2019, 01:25
Forum: Ask For Help
Topic: AHK: Excel_Autofilter
Replies: 3
Views: 349

Re: AHK: Excel_Autofilter

Lang := xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12).row + 1.value ??????? SpecialCells returns a Range object, so you should be able to use Range.Offset like this: Lang := xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12).Offset(1, 0).Value Thank you MsgBox % xl.Wo...
by inseption86
24 Feb 2019, 07:55
Forum: Ask For Help
Topic: AHK: Excel_Autofilter
Replies: 3
Views: 349

AHK: Excel_Autofilter

Hi guys, help me please, how to get value from the second line after the filter

Code: Select all

xl.Worksheets(1).Range("A1:AF1").AutoFilter(7, "eng")
Lang := xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12).row + 1.value ???????

by inseption86
13 Feb 2019, 01:43
Forum: Ask For Help
Topic: AHK: Excel, check data
Replies: 1
Views: 233

AHK: Excel, check data

Hi guys, I have a cell with the date format dd.MM.yyyy, for some reason my code only works under dd Path = %A_Desktop%/*.xlsx Xl := ComObjCreate("Excel.Application") Xl.Workbooks.Open(Path) ;выбрать файл для проверки Xl.Visible := True loop 100 { FormatTime, TimeString, 20171020, dd.MM.yyyy var := X...
by inseption86
07 Feb 2019, 08:30
Forum: Ask For Help
Topic: AHK: Array _Loop
Replies: 2
Views: 217

AHK: Array _Loop

Hi guys, please wait, how to simplify this code : Arr := Array("1", "5", "10","1", "5", "10","1", "5", "10", "1", "5", "10"..........................) Arr1 := Array("0", "0", "0", "1", "1", "1","2", "2", "2","3", "3", "3"........................) loop 100 { ie.document.getElementsByClassName("Nnq7C ...
by inseption86
20 Jan 2019, 00:05
Forum: Ask For Help
Topic: AHK: IE COM_getElementsByTagName Topic is solved
Replies: 15
Views: 1166

Re: AHK: IE COM_getElementsByTagName Topic is solved

@A_AhkUser: Error 0x80010108 on line "while (ie.busy || ie.readyState <> 4)", script is not continue, ie run and all! But if i begin script with admin user - all OK, but I want to run from the regular account
by inseption86
19 Jan 2019, 10:57
Forum: Ask For Help
Topic: AHK: IE COM_getElementsByTagName Topic is solved
Replies: 15
Views: 1166

Re: AHK: IE COM_getElementsByTagName Topic is solved

@A_AhkUser: I did not admin password
by inseption86
19 Jan 2019, 10:42
Forum: Ask For Help
Topic: AHK: IE COM_getElementsByTagName Topic is solved
Replies: 15
Views: 1166

Re: AHK: IE COM_getElementsByTagName Topic is solved

@A_AhkUser: Thank you very mach.


Is it possible to bypass the error "while ie.readyState! = 4" ? If run from under the admin, then everything is OK, if User - not working!

Code: Select all

ie := ComObjCreate("InternetExplorer.Application")
ie.Visible := true
ie.Navigate(URL)

while  ie.readyState!=4
	continue
by inseption86
19 Jan 2019, 08:14
Forum: Ask For Help
Topic: AHK: IE COM_getElementsByTagName Topic is solved
Replies: 15
Views: 1166

Re: AHK: IE COM_getElementsByTagName Topic is solved

@A_AhkUser: Thank you very mach. But, IF var missing? InputBox, var HTMLAnchorElements := ie.document.getElementsByTagName("a") loop % HTMLAnchorElements.length { if (HTMLAnchorElements[ a_index - 1 ].getAttribute("data-profile-id") == var) { matchingElement := HTMLAnchorElements[ a_index - 1 ] matc...
by inseption86
17 Jan 2019, 05:02
Forum: Ask For Help
Topic: AHK: Instagram_unloading followes
Replies: 0
Views: 278

AHK: Instagram_unloading followes

Good day!! Tell me please, "ie.Document.parentWindow.scrollBy (0, Height)" works on the main page, not in the "FOLLOWERS" window, if I do this: "ie.document.getElementsByClassName (" isgrP ") [0] .scrollBy (0, Height) ", it does not work . #NoEnv ; Recommended for performance and compatibility with ...
by inseption86
15 Jan 2019, 11:54
Forum: Ask For Help
Topic: AHK: IE COM_getElementsByTagName Topic is solved
Replies: 15
Views: 1166

Re: AHK: IE COM_getElementsByTagName Topic is solved

thanks, I'll try later. I use inputbox in which I scan the id number, example ""1005454357", <a target="_blank" data-bind="text:LastName() + ' ' + FirstName()+ ' ' + SecondName(), attr:{'data-profile-id':$data.TicketID, 'href': '/********/SearchVisitors/VisitorInfo' + '?profileId=' + $data.ProfileID...
by inseption86
15 Jan 2019, 08:45
Forum: Ask For Help
Topic: AHK: IE COM_getElementsByTagName Topic is solved
Replies: 15
Views: 1166

AHK: IE COM_getElementsByTagName Topic is solved

Hello. Tell me please how to know item if i know the value, example : ie.document.getElementsByTagName("TD")[507].innerText := "1005454357" . I know "1005454357", how do i know "507" ? <a target="_blank" data-bind="text:LastName() + ' ' + FirstName()+ ' ' + SecondName(), attr:{'data-profile-id':$dat...

Go to advanced search