Hi, Not sure if this is VBA solutiion or autohotkey...or both 🤦‍♂️🤣. No way of distinguishing in my file explorer what excel workbooks have connections/queries (Power Query) and which dont. Therefore want to start saving new workbooks containing a query with a "Q" tag. I can then filter on Tag "Q" i...

Hi, Was just about to post this as a new thread after stumbling accross Juho's youtube https://youtu.be/kCmaH9fX3ZA. I've read back through this thread but I cant find a solution to: 1. Add highlight tool...similar to snipping tool when you can highlight diff colours. 2. Change the save option so I ...

Hi,

Is there a way to do this in firefox?

Check if a web pages exists, if this login portal exists then activate otehrwise run?

I know how to do this for prgrams and how to run a web page but I can't piece this together.

Many Thanks
Gareth

Hi,

Sorry I had put the full window title in where you had "Sage".

I also tagged it to bottom of an existing script.

Both ^m & F3 scripts will now bring up the message box when clicked.

...Does this mean its found the button?

Hi Mikey,

Really appreciate your time here .
So nothing fires when I click control m. Only when I click the button do I get the "Test" msg box.

thanks

Hi, I've tried this no joy? ^m:: ControlClick, Price Lists,Sage 50cloud Accounts Professional - GRP(UK)LTD Return Automate my task finds button for actual click.PNG Ive used Automate my task and it doesnt work for a control click but does for an actual click. Is there a way to just send a click to a...

Hi Mikey, apologies yeah I understood your point per what code Ive quoted. But I’m pretty sure I had written that today at work with “Sage 50 Cloud…..”as second parameter. But I’ll revisit when Im back in work tomorrow so I’m not guessing what code I have and haven’t tried so far .

Thank you

Hi, yeah Ive reviewed the literature. Unfortunately I cant get it to work a simple click a button. Ive tried multiple combinations from the ControlClick guide. Im sure Ive attempted this in prior years 🤦🏼‍♂️ Not sure if its my understanding or because ControlClick is just finnickey/buggy anyway. So ...

Hi, been playing around for an hour! ^m:: ControlClick,#SG32DTBUTTON148, Price lists, Sage 50cloud Accounts Professional - GRP(UK)LTD,,,, NA Return Trying to click the "Price List" button? Class NN.PNG Ther class nn button name changes I've noticed so need to go from button text ideally. Many Thanks

Hi,

How do I correct this script please?


Many Thanks
Gareth

Hi, Cant seem to find any existing scripts for navigating shopify sub menus and clicking existing drop down menus. Wish to attempt to make my own shortcuts and scripts. Can someone please advise relevant autohotkey literature to do this please? When using window spy existing shopify buttons arent sh...

Hi, In my accountancy software I can go on overall menu "Customers" then click "Activity"..... then have the option within Activity to change the activity per customer with a A/C drop down. Say if you know you want to look at the activity of numerous customers. OPTION 1 Or "Customers" type customer ...

Hi Russ works great mate .....much appreciated will be big time saver informing the team when delivery is expected.

Hi, your right mikey I should of revisited this script before posting to see if can edit (find a script) to find solution. Its a while since I've looked at this script...to me its complicated :lol: I've definitely skipped learning steps in my understanding but I think this works: ;last working day f...

Hi, I use a script to send today's date, yesterdays date & tomorrows date....for use with a Purchase Order dashboard. Most of our service delivery times are next day. is there a way to do the same but send "last working day" or "next working day"? This is the script that I currently use with day of ...

Maybe I'm misunderstanding the title is of no use to me as will be a different titled csv file each time?

So I just need to make active my csv file by file type some how?

Hi, Thanks for the replies. Scenario Always have multiple excel files open and 1 csv file I'm manipulating. Wish for a hotkey to copy full file path of csv file, open import tool (accs software), then copy data path in this tool ready for import. My crude target method Make csv file active Send, Alt...

Hi,

I was expecting an excel file and csv file to have a different ahk_class. However can see they don't.

Is it possible to see if a file type is active?

Many Thanks
Gareth

So...Ive changed the code per your instruction to this: WinTitle := "Customer Record ahk_class #32770 ahk_exe SBDDesktop.exe" Controls := ["Edit3", "Edit15", "Edit17", "Edit27", "WindowsForms10.BUTTON.app.0.3553390_r30_ad11", "Button6"] Index := 0 F6:: Index := Index = 6 ? 1 : Index + 1 ControlFocus...

Hi, Boiler: the last script youve just posted doesnt find the "?" button. Your first script worked perfectly and found the "?" button. Its just when Ive gone to add the "Address & Contacts" button it cant find it. Smile: Hi thanks for the response. Your script sort of highlights the button (goes blu...