Search found 161 matches

by Portwolf
04 Dec 2019, 15:44
Forum: Ask for Help (v1)
Topic: Excel 2 GUI Topic is solved
Replies: 10
Views: 2665

Re: Excel 2 GUI Topic is solved

Adapted and working!!
Thanks mate!

Image
by Portwolf
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 :)
by Portwolf
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...
by Portwolf
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 :D

That is perfect!! Thanks so much. I could never gotten there :D
Only one question, after i ran the code, now workbook says it is locked, even after closing GUI.
by Portwolf
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...
by Portwolf
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...
by Portwolf
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! :D

Much appreciated :clap:
by Portwolf
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...
by Portwolf
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...
by Portwolf
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 ...
by Portwolf
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...
by Portwolf
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 :bravo:

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 :mrgreen:
by Portwolf
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 :HeHe:
by Portwolf
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:

Code: Select all

*RShift::Send % "{Shift " ((i:=!i) ? "Down}" : "Up}")
You will be able to toggle shift-down/shift-up with the right shift key.
by Portwolf
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...
by Portwolf
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?
by Portwolf
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()
?
by Portwolf
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".
by Portwolf
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:

Code: Select all

StringReplace,Subject,Subject,`n,,A
StringReplace,Subject,Subject,`r,,A
Remove the line breaks from the var, i have no idea on how they are there in the first place, but, it is solved..
by Portwolf
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...

Go to advanced search