Search found 26 matches

by Mannaia666
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).
by Mannaia666
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...
by Mannaia666
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...
by Mannaia666
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...
by Mannaia666
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 ...
by Mannaia666
16 Jan 2023, 04:12
Forum: Ask for Help (v1)
Topic: single instance
Replies: 1
Views: 296

Re: single instance

Code: Select all

#SingleInstance
add this on the script.
by Mannaia666
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%
by Mannaia666
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...
by Mannaia666
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!
by Mannaia666
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
by Mannaia666
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!
by Mannaia666
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!

Code: Select all

ThisItem.Display
put before the "ThisItem.UnRead" will do the trick.
Thanks!
by Mannaia666
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...
by Mannaia666
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:

Code: Select all

for each in Xl.ActiveWorkbook.Names
	Xl.ActiveWorkbook.Names.Item(each.Name).Delete()
that will prevent both errors!
TY!
by Mannaia666
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...
by Mannaia666
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...
by Mannaia666
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...
by Mannaia666
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 ...

Go to advanced search