AutoHotkey Community

Barn01

Could someone take a few mins and make this 8 line macro in PMC. Just open an excel sheet and dump some random numbers in Column A for the test. This code runs fine when I'm running it in SciTE4 but gives me a mismatch array error at "Cells" when I try it in PMC. I'm just wondering if this is a bug?...

Barn01

So I remade the script in PMC and it fails just like it did before. It seems there's a problem with using XL.Cells(var1, var2).Value in a while loop. If I use numbers in place of the var then it works fine, but of course I can't do that for my script to run. Any ideas? Can someone test this if they ...

Barn01

Kon thanks for your help!! I finally got it working. I abandoned trying to sort it out on PMC and used SciTE4 instead and that variable window while stepping is a life saver!!! I haven't coded in 20+ yrs but after a couple hours of hair pulling it started coming back. I'm just not familiar with AHK ...

Barn01

grassi wrote:SciTE4AHK300601_Install is on my mega drive: https://mega.nz/#!lgxVDBpT!b7Ctvzyvbsuk ... l-pjdwdlB0. Hope this helps.

Thanks

Barn01

It's pretty wierd. If I change the inner While loop to a For loop until (same expression) then it passes (minus some logic that is screwed up). So why does the While loop fail? While XL.Cells(cnt , pctCol).Value != "" to this Loop { pctFactor := XL.Cells(cnt , pctCol).Value MsgBox, 0, , %label% = %p...

Barn01

I've tried a variety of things now and I still get the same error on that while loop. I've put in a msg box above the while statement and cnt = 1 (row), and pctCol = 10 (col J). I get the error msg right after I press ok. I'm not sure why the while loop fails? Possible bug in PMC? It's a little hard...

Barn01

Thank you both that defiantly makes it much cleaner. I'm new to AHK as you can tell. However I'm still getting an Array error at this line.

Code: Select all

While XL.Cells(cnt , pctCol).Value != ""

Type mismatch
Cells

Barn01

I'm using PMC and I don't know what I'm doing wrong of course. I just want to loop through rows and columns. Basically I have 1 or more tables that are various sizes and are shown down sheets in a workbook. I want to save a selected cell in the table to a variable so that I can write it to an input ...

Barn01

Both work

Thanks
and kon that's awesome, above and beyond

Barn01

I know this should be simple but I keep getting an error at the variable when selecting the sheet. I've tried with quotes outside the % and same error. This is just a snippet of the code so you get an idea of what I'm trying to do. I should note that I'm also using PMC to make the script. If !IsObje...

Barn01

I'm impressed! Although I'm still not exactly sure what I was missing. label vs %label% ... I'm wondering is that's what it was? However I thought that if you don't use the % signs that you keep filling the variable buffer. So since I would be using the variable with a different value every iteratio...

Barn01

Well I've exhausted every combination of things I could find and make up. I honestly don't think you can send % in a variable to a text box via getElementsByName (or any other ID tag). I've resorted to copying the variable to the %clipboard% and using a click command to select the box and ^V command...

Barn01

These elements don't have IDs, so getElementByID doesn't make sense. Well then you can use getElementsByName This example only sends "work" and I want it to send "work%work" If !IsObject(ie) ie := ComObjCreate("InternetExplorer.Application") ie.Visible := true ie.Navigate("http://www.roboform.com/f...

Barn01

Can anyone send a % to a text box on:
http://www.roboform.com/filling-test-all-fields
Using getElementByID to pass the variable?

Barn01

That didn't work either

Barn01

Here's the snippet I tried and it doesn't work. Same result with only Div being passed to the txt box. StringReplace, label, label, % , `% , All Sleep, 333 If !IsObject(ie) ie := ComObjCreate("InternetExplorer.Application") ie.Visible := true ie.document.getElementByID("label").Value := label Sleep,...

Barn01

I'm not sure I understand. If the variable already contains the modified `% and it still doesn't send then how is replacing the string with the same thing going to help?

Barn01

That didn't work. I tried changing the variable in the cell to add the ` but when it prints it to the txt box on the web page it only shows Div ... just like before

The variable loading from the cell is good as tested with a msg box. Why won't it print to a web form txt box?

Barn01

Guest wrote:Remove the %% like so XL.Range("C" count)

That didn't work.
Again, my code does send the correct value to a msg box with the % intact. The variable %label% is truncated at the % in the string when using getElement.... .

Barn01

I know this is going to sound stupid but I can't figure out how to send a variable that contains a % to a text box on a webpage. The cell value = Div%ChgA but when I sent it to a text box using the below code it only sends Div I've tried changing from Value to Text but that didn't work. I've tried s...

Search found 23 matches

Re: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool

Re: Increment Columns in Excel

Re: Increment Columns in Excel

Re: Working Link of SciTE4ahk

Re: Increment Columns in Excel

Re: Increment Columns in Excel

Re: Increment Columns in Excel

Increment Columns in Excel

Re: Activate an Excel Sheet with a Variable Name Topic is solved

Activate an Excel Sheet with a Variable Name Topic is solved

Re: Can't send % to text box

Re: Can't send % to text box

Re: Can't send % to text box

Re: Can't send % to text box

Re: Can't send % to text box

Re: Can't send % to text box

Re: Can't send % to text box

Re: Can't send % to text box

Re: Can't send % to text box

Can't send % to text box