Search found 26 matches
- 23 Feb 2024, 07:57
- Forum: Ask for Help (v1)
- Topic: Retriving all cell of a column in an Excel files that contain a specific value Topic is solved
- Replies: 8
- Views: 363
Re: Retriving all cell of a column in an Excel files that contain a specific value Topic is solved
i wold like to thanks you all, that will be a lot of things to read (and a lot of script to tune-up).
- 22 Feb 2024, 05:23
- Forum: Ask for Help (v1)
- Topic: Retriving all cell of a column in an Excel files that contain a specific value Topic is solved
- Replies: 8
- Views: 363
Re: Retriving all cell of a column in an Excel files that contain a specific value Topic is solved
Thanks, Here is were the arrays come in and my brain goes out :D i think the main problem is that i don't know the basic operation with array, and everytime i search for a tutorial i only find either hyper-complex one or hyper-semplified tutorial that didn't give me a real use. did someone have a tu...
- 20 Feb 2024, 08:32
- Forum: Ask for Help (v1)
- Topic: Retriving all cell of a column in an Excel files that contain a specific value Topic is solved
- Replies: 8
- Views: 363
Re: Retriving all cell of a column in an Excel files that contain a specific value Topic is solved
Example: DateLookUp := "foobar" xl := ComObjCreate("Excel.Application") xl.Visible := True ; Rendi Excel visibile xl.Workbooks.Open(Filename) rng := xl.sheets(1).range("A:A") foundCell := rng.Find(DateLookUp) msgbox % "found`n" foundCell.offset(0,1).Value "`n" foundCell.offset(0,2).value if (foundC...
- 20 Feb 2024, 06:03
- Forum: Ask for Help (v1)
- Topic: Retriving all cell of a column in an Excel files that contain a specific value Topic is solved
- Replies: 8
- Views: 363
Retriving all cell of a column in an Excel files that contain a specific value Topic is solved
Hello there! i'm writing a script and i need to retrive the position of a specific cell, if find take data from Column B and C and display them, i've found this: xl := ComObjCreate("Excel.Application") xl.Visible := True ; Rendi Excel visibile workbook := xl.Workbooks.Open(Filename) worksheet := wor...
- 18 Apr 2023, 09:03
- Forum: Ask for Help (v1)
- Topic: How can I loop this every 60 minutes?
- Replies: 2
- Views: 333
Re: How can I loop this every 60 minutes?
You can do something like that: TimeNeeded := SubStr(A_Now, -5, 4) ;extract from the var A_Now actual hours and minutes ;msgbox, %TimeNeeded% Loop { if (TimeNeeded = 0802) ;check if hours and minutes are the one needed to start the script { SetTimer, Run, 3600000 ; set the label RUN to be run every ...
- 16 Jan 2023, 04:16
- Forum: Ask for Help (v1)
- Topic: how to pause script and continue where it was left off autohotkey
- Replies: 2
- Views: 1246
Re: how to pause script and continue where it was left off autohotkey
so, you can use
Code: Select all
F3::Pause
- 16 Jan 2023, 04:12
- Forum: Ask for Help (v1)
- Topic: single instance
- Replies: 1
- Views: 296
Re: single instance
Code: Select all
#SingleInstance
- 16 Jan 2023, 04:10
- Forum: Ask for Help (v1)
- Topic: Can autohotkeys cause high disk usage
- Replies: 11
- Views: 873
Re: Can autohotkeys cause high disk usage
as long as you don't call any hotkey the disk use caused by the script should be 0%
- 16 Jan 2023, 03:08
- Forum: Ask for Help (v1)
- Topic: Can autohotkeys cause high disk usage
- Replies: 11
- Views: 873
Re: Can autohotkeys cause high disk usage
There seems to be nothing that can cause a high disk usage in this script, unless you keep spamming the hotkey calling excell and opening sites, but that will use the disk just until the software is run, then it should stop using it. if you see a high disk usage even when all is still, maybe you can...
- 12 Jan 2023, 08:14
- Forum: Ask for Help (v1)
- Topic: Can autohotkeys cause high disk usage
- Replies: 11
- Views: 873
Re: Can autohotkeys cause high disk usage
Yes, it's possible to archive a high disk usage with a script, but that depend on what your script do, far more than how many line of code there is.
if you want (and if you can) put your script here so we can look for something that can cause the problem you are talking.
let us know!
if you want (and if you can) put your script here so we can look for something that can cause the problem you are talking.
let us know!
- 12 Jan 2023, 05:49
- Forum: Ask for Help (v1)
- Topic: count of rows used
- Replies: 2
- Views: 348
Re: count of rows used
normaly i use this command:
Code: Select all
LastRow := xlsm.activesheet.UsedRange.rows.count
- 03 Jan 2023, 05:28
- Forum: Scripts and Functions (v1)
- Topic: PaddleOCR - probably the best OCR tool available
- Replies: 75
- Views: 31007
Re: PaddleOCR - probably the best OCR tool available
Hello There, is there someone who can explain me briefly how to set the PaddleOcr to work with italian language?
Thanks!
Thanks!
- 13 Sep 2022, 07:55
- Forum: Ask for Help (v1)
- Topic: Open a specific email in new window Topic is solved
- Replies: 1
- Views: 270
Re: Open a specific email in new window Topic is solved
Found out!
put before the "ThisItem.UnRead" will do the trick.
Thanks!
Code: Select all
ThisItem.Display
Thanks!
- 13 Sep 2022, 05:17
- Forum: Ask for Help (v1)
- Topic: Open a specific email in new window Topic is solved
- Replies: 1
- Views: 270
Open a specific email in new window Topic is solved
Hello! I've wrote the code below by reading a lot of post, he do near all that i need it to do, the last thing i need is to open the found mail in a new window. the script run every 10 seconds and check the unread mail, if a mail contain the word "Titolo" in the title it should open it in a new wind...
- 16 Jun 2022, 01:42
- Forum: Ask for Help (v1)
- Topic: Error opening an Excel file Topic is solved
- Replies: 2
- Views: 488
Re: Error opening an Excel file Topic is solved
That was what i was searching for! (<- is that a correct english sentence?)
so, with a little tuning i've got:
that will prevent both errors!
TY!
so, with a little tuning i've got:
Code: Select all
for each in Xl.ActiveWorkbook.Names
Xl.ActiveWorkbook.Names.Item(each.Name).Delete()
TY!
- 15 Jun 2022, 07:08
- Forum: Ask for Help (v1)
- Topic: Error opening an Excel file Topic is solved
- Replies: 2
- Views: 488
Error opening an Excel file Topic is solved
Hello there, i need some help with an error caused by applying filters to a file, the problem first started when i've tryed to automate some operation on it. the first time I make a script open that file an error of "Name conflict" calling for an old name: "_FilterDatabase" asking for a new name. af...
- 06 Apr 2022, 08:11
- Forum: Ask for Help (v1)
- Topic: Need help with existing script
- Replies: 5
- Views: 568
Re: Need help with existing script
in the first commands called by CTRL + Alt + s and 2 and 1 there's a missing comma after the send everytime you use one of this command the script will be closed. Why do you say this? The comma is optional. It is optional for all commands. All the examples in the Send documentation actually show it...
- 06 Apr 2022, 04:21
- Forum: Ask for Help (v1)
- Topic: Need help with existing script
- Replies: 5
- Views: 568
Re: Need help with existing script
I've taked a look at the script, there's a lot ok tuning that can be done, let's start in order. in the first commands called by CTRL + Alt + s and 2 and 1 there's a missing comma after the send everytime you use one of this command the script will be closed. all the {CTRLDOWN}s{CTRLUP} can be repla...
- 01 Apr 2022, 05:03
- Forum: Ask for Help (v1)
- Topic: Retrieve date of a recived email from Outlook Topic is solved
- Replies: 3
- Views: 368
Re: Retrieve date of a recived email from Outlook Topic is solved
that was exactly what i wanted!
Thanks!
Thanks!
- 01 Apr 2022, 04:43
- Forum: Ask for Help (v1)
- Topic: Retrieve date of a recived email from Outlook Topic is solved
- Replies: 3
- Views: 368
Retrieve date of a recived email from Outlook Topic is solved
Hello There! i'm trying to retrieve the data of a recived email (opened in a separate windows) via Com Call, i've see a post https://www.autohotkey.com/boards/viewtopic.php?f=76&t=93604&p=414653&hilit=ComObjActive+Outlook.Application+.ActiveWindow.CurrentItem#p414653 that do something similar but i ...