Adapted and working!!
Thanks mate!
Search found 161 matches
- 04 Dec 2019, 15:44
- Forum: Ask for Help (v1)
- Topic: Excel 2 GUI Topic is solved
- Replies: 10
- Views: 2665
- 04 Dec 2019, 14:28
- Forum: Ask for Help (v1)
- Topic: Excel 2 GUI Topic is solved
- Replies: 10
- Views: 2665
Re: Excel 2 GUI Topic is solved
Hi! Sorry, was away on work.
Thank, i will try it now
Will give feedback as soon as possible
Thank, i will try it now
Will give feedback as soon as possible
- 22 Nov 2019, 04:08
- Forum: Ask for Help (v1)
- Topic: Excel 2 GUI Topic is solved
- Replies: 10
- Views: 2665
Re: Excel 2 GUI Topic is solved
Thanks for the update, i was checking it again and the object close is on the code you provided earlier. Apparently i tried to open the Excel while AHK was still open, and that was the issue.. As we call it at work, it was a "layer 8 mistake" lololol :D Thanks mate! Also, sorry for spamming you with...
- 21 Nov 2019, 10:09
- Forum: Ask for Help (v1)
- Topic: Excel 2 GUI Topic is solved
- Replies: 10
- Views: 2665
Re: Excel 2 GUI Topic is solved
Hi Rinaldo
That is perfect!! Thanks so much. I could never gotten there
Only one question, after i ran the code, now workbook says it is locked, even after closing GUI.
That is perfect!! Thanks so much. I could never gotten there
Only one question, after i ran the code, now workbook says it is locked, even after closing GUI.
- 21 Nov 2019, 09:16
- Forum: Ask for Help (v1)
- Topic: Excel 2 GUI Topic is solved
- Replies: 10
- Views: 2665
Re: Excel 2 GUI Topic is solved
Hi, yeah, it does. I am using this: #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. ; #Warn ; Enable warnings to assist with detecting common errors. SendMode Input ; Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_Scrip...
- 21 Nov 2019, 06:45
- Forum: Ask for Help (v1)
- Topic: Excel 2 GUI Topic is solved
- Replies: 10
- Views: 2665
Excel 2 GUI Topic is solved
Hi guys, I've looked around but haven't found any answers.. Only found this topic that partially answers my question: https://www.autohotkey.com/boards/viewtopic.php?f=76&t=64969&p=278966#p278966 I needed to gather data from an Excel file, a range, and display it on a GUI. I've seen that i can use L...
- 28 Aug 2019, 08:02
- Forum: Ask for Help (v1)
- Topic: Parsing clipboard partially Topic is solved
- Replies: 4
- Views: 1078
Re: Parsing clipboard partially Topic is solved
Thank you! Very interesting solution, i will work with that!
Much appreciated
Much appreciated
- 28 Aug 2019, 05:28
- Forum: Ask for Help (v1)
- Topic: Parsing clipboard partially Topic is solved
- Replies: 4
- Views: 1078
Parsing clipboard partially Topic is solved
Hello all, I am using this to parse the clipboard: Loop, Parse, Clipboard, `n Data%A_Index% := A_LoopField So, now i need to find the line where the text "message" is and output the next line to a var. I can output it directly by using: msgbox, %Data12% But i wanted it to search for the word "messag...
- 24 Jul 2019, 19:06
- Forum: Ask for Help (v1)
- Topic: Lynda.com workaround
- Replies: 28
- Views: 9548
Re: Lynda.com workaround
Hi boys, So, i've looked at the HTML and the course information is inside these sections: <a class="mini-card mini-card--flat mini-card--link mini-learning-card" data-tracking-control-name="search-result_learning_card_title" data-tracking-will-navigate href="https://www.linkedin.com/learning/learnin...
- 24 Jul 2019, 00:36
- Forum: Ask for Help (v1)
- Topic: Lynda.com workaround
- Replies: 28
- Views: 9548
Re: Lynda.com workaround
Hi boys, So, this was working perfectly until Lynda.com integrated with Linked In, and after a website revamp, the scrapper stopped working properly. I now needed to scrape from another address, but the HTML all changed as well, so im stuck on this issue again. I was using: #NoEnv ; Recommended for ...
- 17 Jul 2019, 03:52
- Forum: Ask for Help (v1)
- Topic: DB connection on server
- Replies: 0
- Views: 623
DB connection on server
Hello all, Does anyone have a solution to connect to a database over the internet? I am trying to set up a connection to a hosted database. Lets say this is the data: dbaddress: 123.123.123.123 dbport: 3039 dbname: thisusername dbuser: thispassword I needed to query the database to get specific data...
- 13 Jul 2019, 23:01
- Forum: Ask for Help (v1)
- Topic: Need help Topic is solved
- Replies: 5
- Views: 1133
Re: Need help Topic is solved
Glad it worked
I can relate to that... Took me nearly 3 days to find out how to do stuff that i now can do without even thinking about it.
We all start somewhere
I can relate to that... Took me nearly 3 days to find out how to do stuff that i now can do without even thinking about it.
We all start somewhere
- 13 Jul 2019, 22:57
- Forum: Ask for Help (v1)
- Topic: Trying to read a file and output text Topic is solved
- Replies: 5
- Views: 1881
Re: Trying to read a file and output text Topic is solved
Well, that's kind of a BIG way to get started in AHK..
You will want to take a look at AHKLiza by derRaphael.
Little warning, you have a LOT of work in front of you
You will want to take a look at AHKLiza by derRaphael.
Little warning, you have a LOT of work in front of you
- 13 Jul 2019, 22:53
- Forum: Ask for Help (v1)
- Topic: Need help Topic is solved
- Replies: 5
- Views: 1133
Re: Need help Topic is solved
Ahh... ok
https://www.autohotkey.com/docs/Hotkeys.htm#Symbols
Look for "UP", and you will find the "DOWN" as well.
Try this:
You will be able to toggle shift-down/shift-up with the right shift key.
https://www.autohotkey.com/docs/Hotkeys.htm#Symbols
Look for "UP", and you will find the "DOWN" as well.
Try this:
Code: Select all
*RShift::Send % "{Shift " ((i:=!i) ? "Down}" : "Up}")
- 13 Jul 2019, 22:31
- Forum: Ask for Help (v1)
- Topic: Screen capture - Selected area
- Replies: 7
- Views: 6074
Re: Screen capture - Selected area
I had the same issue. Ended up using IrfanView. This is a GUI i built that took the screenshot uppon as soon as it was called (by external program) and saved the screenshot. This is multi-monitor also, sould work for you with minor tweaks. Also has a nice animated gif on the alarm opening.. :D #NoEn...
- 13 Jul 2019, 22:21
- Forum: Ask for Help (v1)
- Topic: Trying to read a file and output text Topic is solved
- Replies: 5
- Views: 1881
Re: Trying to read a file and output text Topic is solved
Hello,
Yeah, that is a mess indeed
But it's doable.
Where do you want to send the commands to?
What are the commands? Text? Keypresses?
FileAppend is meant as file appending, not reading.
It outputs the data (variable) to a file.
Do you want to build a chat-bot, is that it?
Yeah, that is a mess indeed
But it's doable.
Where do you want to send the commands to?
What are the commands? Text? Keypresses?
FileAppend is meant as file appending, not reading.
It outputs the data (variable) to a file.
Do you want to build a chat-bot, is that it?
- 13 Jul 2019, 22:17
- Forum: Ask for Help (v1)
- Topic: Website click
- Replies: 1
- Views: 498
Re: Website click
Code: Select all
WB.Document.getElementbyId("wp-admin-bar-edit").Click()
- 13 Jul 2019, 22:16
- Forum: Ask for Help (v1)
- Topic: Need help Topic is solved
- Replies: 5
- Views: 1133
Re: Need help Topic is solved
Hello,
If it is a CAPS TEXT THING, why not just press caps-lock?
If you have another use for it, let us know then, keeping the key pressed might trigger other SO functions such as "sticky keys".
If it is a CAPS TEXT THING, why not just press caps-lock?
If you have another use for it, let us know then, keeping the key pressed might trigger other SO functions such as "sticky keys".
- 13 Jul 2019, 22:13
- Forum: Ask for Help (v1)
- Topic: Outlook Subject - missing info from var Topic is solved
- Replies: 1
- Views: 724
Re: Outlook Subject - missing info from var Topic is solved
Fixed it:
Remove the line breaks from the var, i have no idea on how they are there in the first place, but, it is solved..
Code: Select all
StringReplace,Subject,Subject,`n,,A
StringReplace,Subject,Subject,`r,,A
- 13 Jul 2019, 00:19
- Forum: Ask for Help (v1)
- Topic: Outlook Subject - missing info from var Topic is solved
- Replies: 1
- Views: 724
Outlook Subject - missing info from var Topic is solved
Hello all, I am using a tool to automate an email. This takes several info from a GUI and puts it on the email subject. The contents of the variables are somewhat huge, but the customer wants it on the email subject... :facepalm: So, on the email subject i have to put: Subject = [Customer] INCIDENCE...