Search found 23 matches

by Barn01
22 Sep 2016, 19:59
Forum: Pulovers Macro Creator
Topic: Pulover's Macro Creator v5.0.5 - The Complete Automation Tool
Replies: 1007
Views: 632520

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

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?...
by Barn01
22 Sep 2016, 16:27
Forum: Ask For Help
Topic: Increment Columns in Excel
Replies: 10
Views: 2500

Re: Increment Columns in Excel

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 ...
by Barn01
22 Sep 2016, 11:09
Forum: Ask For Help
Topic: Increment Columns in Excel
Replies: 10
Views: 2500

Re: Increment Columns in Excel

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 ...
by Barn01
21 Sep 2016, 10:01
Forum: SciTE4AutoHotkey
Topic: Working Link of SciTE4ahk
Replies: 2
Views: 4400

Re: Working Link of SciTE4ahk

grassi wrote:SciTE4AHK300601_Install is on my mega drive: https://mega.nz/#!lgxVDBpT!b7Ctvzyvbsuk ... l-pjdwdlB0. Hope this helps.
Thanks :)
by Barn01
20 Sep 2016, 20:17
Forum: Ask For Help
Topic: Increment Columns in Excel
Replies: 10
Views: 2500

Re: Increment Columns in Excel

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...
by Barn01
20 Sep 2016, 17:09
Forum: Ask For Help
Topic: Increment Columns in Excel
Replies: 10
Views: 2500

Re: Increment Columns in Excel

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...
by Barn01
20 Sep 2016, 15:03
Forum: Ask For Help
Topic: Increment Columns in Excel
Replies: 10
Views: 2500

Re: Increment Columns in Excel

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
by Barn01
20 Sep 2016, 14:15
Forum: Ask For Help
Topic: Increment Columns in Excel
Replies: 10
Views: 2500

Increment Columns in Excel

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 ...
by Barn01
16 Sep 2016, 21:54
Forum: Ask For Help
Topic: Activate an Excel Sheet with a Variable Name Topic is solved
Replies: 4
Views: 1249

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

Both work

Thanks
and kon that's awesome, above and beyond :)
by Barn01
16 Sep 2016, 21:11
Forum: Ask For Help
Topic: Activate an Excel Sheet with a Variable Name Topic is solved
Replies: 4
Views: 1249

Activate an Excel Sheet with a Variable Name Topic is solved

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...
by Barn01
23 Aug 2016, 14:13
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

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...
by Barn01
22 Aug 2016, 15:02
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

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...
by Barn01
21 Aug 2016, 12:04
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

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...
by Barn01
21 Aug 2016, 10:36
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

Can anyone send a % to a text box on:
http://www.roboform.com/filling-test-all-fields
Using getElementByID to pass the variable?
by Barn01
21 Aug 2016, 08:13
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

That didn't work either :(
by Barn01
21 Aug 2016, 07:45
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

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,...
by Barn01
21 Aug 2016, 06:57
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

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?
by Barn01
21 Aug 2016, 06:43
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

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?
by Barn01
21 Aug 2016, 05:29
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Re: Can't send % to text box

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.... .
by Barn01
20 Aug 2016, 22:09
Forum: Ask For Help
Topic: Can't send % to text box
Replies: 17
Views: 2953

Can't send % to text box

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...

Go to advanced search