AutoHotkey Community

eblanc

This is not what you're looking for but in Lintalist https://www.autohotkey.com/boards/viewtopic.php?f=6&t=3378 you can nest snippets (among other things) - you can have a snippet with a hotstring %CA01 -> CA Far Northern California and you can have another snippet with this content: Some text, mor...

eblanc

Hi Everyone, I built a COM OBJ script that pulls data value from excel. And it works. I also have a script that finds a folder directory based on the first characters. It also works! So now I want to combine them both to make a super mega ultra-powered bundle of scripting that will find my excel fil...

eblanc

Rohwedder Didn't work. It omits the number sign (#) I actually found a way it kind of works. Not my preferred method but the best I got. Adding a label, and subroutine command. %CA01: ::%CA01:: send, CA Far Northern California return %NY: ::%NY03:: send, NY Genesee Valley and Northern Frontier retu...

eblanc

And also, could I turn the second hosting into a variable? Script is big, But I'm going to try to simplify. I have a chart of hotstrings based on state territory, example: %CA01 %NY03 %WA02 %Tx02 %TX03 etc... Each one basically gives me airport codes. Now I have another script that would like to ref...

eblanc

What are you using? what is your code?

eblanc

flyingDman wrote: ↑
25 Jun 2019, 17:15
It is XL not X1!

Damn!! Very good eye!!!! how details like that are hard to see.

xl vs x1 in ahk, look exactly 100% the same.

Output now is correct:

Code: Select all

KILO
Enrique Iglesias
NA99
 55555
 pass12345
 pass99999
 pass12345
 359225055900000
 8914800000017000000

Thanks @flyingDman

eblanc

awel20 Sweet, thanks! I had like 14 excel processes running in the background, burning my CPU. hahaha I tried this. And it works great. Except that I'm not getting the first values of the sheet. Kind of odd. Just thought I'd bring it up in case you might know what's causing it. Cause I might just w...

eblanc

Lots of confusion here. This code: xl := ComObjCreate("Excel.Application") xl.Visible := false ; Make the application visible xl.Workbooks.Open("C:\Users\Enrique\Desktop\Codes\Excel COM\TEST - 00000 - Comobject Test Sheet.xlsx") ::#cam1:: xl := ComObjGet("C:\Users\Enrique\Desktop\Codes\Excel COM\TE...

eblanc

@awel20 Also forgot to mention, you've helped me a couple of times. Lots actually. I really appreciate it. Something I aspire to do once I understand this language better.

eblanc

Send, % xl.Worksheets("Sheet1").Range("B11").Value ComObjGet gets a workbook not an applicaiton Thanks Awel! You've solved my problem, kind of feel like a ghost that is gonna fade away after completing it's unfinished business on this world *thanks awel....* Voice Fades away... Hahaha, this will ge...

eblanc

::#cam1:: xl := ComObjGet("C:\Users\Enrique\Desktop\Codes\Excel COM\TEST - 00000 - Comobject Test Sheet.xlsx") Send, % x1.Range("B3").value Send, % xl.Range("B11").Value return :?: I get an error. Error 0x80020006 - Unknown Name. Specificially: Range. ---> 014: Send, x1.range("B11").value This is t...

eblanc

I'm subscribing, curious to know what it is.

eblanc

Unfortunately you didn't provide the Excel file, so I did one by myself in the same "order" (see attached file). If you place the Excel in c:\temp and run this script, a message box will provide you in every loop the content of column 1-5 Use this a blueprint. Sweet Man! This is getting a lot close...

eblanc

I did a similar script to read from Excel and write in SAP GUI. To read from Excel object I use the cells function, because it uses number and you can use a loop. But I don't understand your code. First you're setting the cells, then you send undefined variables. If I understand your question, then...

eblanc

Found IT! ! ! It was that send, ^w was different from send, ^W (Capital W closes all windows, duh....) Now it works!! ! ! fixed a few things like adding a label if it does recognize the page is loaded ^+m:: inputbox, userinput, Automated Mac Address, How many Mac Addresses in Sequence am I updating?...

eblanc

I removed Escape, and changed te firefox settings to NOT close multiple tabs.

I found that it's trying to close multiple tabs, so it must be a command. I'm inadvertently using? I'm gonna spam msgbox in my code until I find where exactly is stopping

eblanc

After the first inner loop 'timed out', which action should change the conditions when the outer loop continues? What is Send, {escape} intended to do? What is Send, ^w intended to do (if sent to a firefox window with only one tab, it will close the whole window)? Hi Just me, Escape is intended to ...

eblanc

That is a good point SOTE , I didn't mention it because it never worked for me. It also gets a little bit more complicated. Cropping image + calculating search box, having the picture with the same folder, slow processing if a big search box, and just plainly more difficult to get it to work. in the...

eblanc

I've searched and read a couple of different things on Excel Com Obj, I usually feel like I have an information overload. What I need to do is fairly simple. I just need to read the data from couple of cells in an excel workbook, and I'll be ouputting them out to a webpage browser later, For now, I'...

eblanc

Hi Everyone, this took me a while to find, And I wanted to share. My main script was intended to check if a page was loaded and if so to start the script. Instead of doing things manually or putting a Sleep timer that could be inaccurate or too time-consuming. I am using pixelgetcolor to check if a ...

Search found 71 matches

Re: Is it possible to reference a hotstring, in another hotstring??

Finding Excel File. Loop, Files Topic is solved

Re: Is it possible to reference a hotstring, in another hotstring??

Is it possible to reference a hotstring, in another hotstring??

Re: run ahk in extended monitor

Re: Basic Excel Com Obj script Topic is solved

Re: Basic Excel Com Obj script Topic is solved

Re: Basic Excel Com Obj script Topic is solved

Re: Basic Excel Com Obj script Topic is solved

Re: Basic Excel Com Obj script Topic is solved

Re: Basic Excel Com Obj script Topic is solved

Re: Sorting values pivot table COM Topic is solved

Re: Basic Excel Com Obj script Topic is solved

Re: Basic Excel Com Obj script Topic is solved

Re: Adding timers to a loop Topic is solved

Re: Adding timers to a loop Topic is solved

Re: Adding timers to a loop Topic is solved

Re: How to Check if Webpage is Loaded (Google Chrome, Firefox, Internet Explorer)

Basic Excel Com Obj script Topic is solved

How to Check if Webpage is Loaded (Google Chrome, Firefox, Internet Explorer)