Search found 104 matches

by rjw524
Mon Jun 20, 2016 3:40 pm
Forum: Technical / Scripting
Topic: Selecting an image when there are multiple copies of it
Replies: 6
Views: 6011

Selecting an image when there are multiple copies of it

Hello, I am working from a list on a dynamically generated web page. The only real identifier on the page is the empty checkbox next to each record in the list of results. I need to open each record (done by clicking each box) individually. Problem is, for each list of results there are anywhere fro...
by rjw524
Mon May 23, 2016 4:30 pm
Forum: Technical / Scripting
Topic: Need Help with a Loop Counter...
Replies: 4
Views: 5003

Re: Need Help with a Loop Counter...

Hi, yes you add one in the beginning of the big loop and then also in the small loop, ie twice so it increments 0,2,4, ... The other thing I changed was to make sure to set focus on the right window, otherwise there is always the risk that you are comparing different bitmaps than you think. If you ...
by rjw524
Mon May 23, 2016 1:23 pm
Forum: Technical / Scripting
Topic: Need Help with a Loop Counter...
Replies: 4
Views: 5003

Re: Need Help with a Loop Counter...

hagchr, hey, this is great! thanks so much! I hope you don't mind me asking a question or two of you here in an attempt to understand what I did wrong... So when I did the following: Let>k=k+1 and later followed up with the Add>k,1 that was essentially adding 2 to the counter instead of just 1? Is t...
by rjw524
Mon May 23, 2016 3:58 am
Forum: Technical / Scripting
Topic: Need Help with a Loop Counter...
Replies: 4
Views: 5003

Need Help with a Loop Counter...

Hi, I'm trying to create a loop that does the following: Compare the screen captured image of an area on the screen to later images of the same area. If the images are similar enough then the loop counter would increase by 1. If the images are not similar enough, the loop counter would start over at...
by rjw524
Thu Apr 28, 2016 5:00 pm
Forum: Technical / Scripting
Topic: Trouble Sending a Variable to Excel...
Replies: 3
Views: 3687

Re: Trouble Sending a Variable to Excel...

Hi Marcus and JRL, Thanks for taking a look and testing it for me! After getting confirmation that the code was written correctly, I focused on the steps higher up in the macro and found the problem. (it's a long macro) FAR up in the macro I made a mistake that was unintentionally not allowing the v...
by rjw524
Wed Apr 27, 2016 6:19 pm
Forum: Technical / Scripting
Topic: Trouble Sending a Variable to Excel...
Replies: 3
Views: 3687

Trouble Sending a Variable to Excel...

Hi all, Can anyone tell me why this use of a variable found using the "Let" command is passing the variable to Excel? Instead it's passing along either "%WhereYaAt%" or "WhereYaAt" depending on whether or not I enclose the variable with %. VBSTART Dim objExcel Sub GetExcel Set objExcel = GetObject( ...
by rjw524
Fri Jan 29, 2016 9:47 pm
Forum: Technical / Scripting
Topic: Get the "address" or coordinates of a cell in excel...
Replies: 2
Views: 2763

Re: Get the "address" or coordinates of a cell in excel...

Please disregard this post unless you want to keep it up for others who may ask. Or flag it as "Solved". I must be getting punchy. I looked through the forums again and found this almost instantly. (*Many thanks to JRL and hagchr who both presented options that worked. Below is hagchr's code...) VBS...
by rjw524
Fri Jan 29, 2016 9:33 pm
Forum: Technical / Scripting
Topic: Get the "address" or coordinates of a cell in excel...
Replies: 2
Views: 2763

Get the "address" or coordinates of a cell in excel...

Hi All, Quick question...(this problem can't be as hard as it's turning out to be, right?) Let's say you perform a copy command of a cell on a specific sheet of an excel workbook. Is there some kind of way in MS14 to get and store the address or coordinates of the copied cell as a variable for later...
by rjw524
Thu Jan 21, 2016 7:02 pm
Forum: Technical / Scripting
Topic: Window moves when it's in the mood???
Replies: 3
Views: 3118

Re: Window moves when it's in the mood???

Hi guys,

I added a bit more time to the wait and that seemed to solve the problem. Come to think of it that speaks to both of your points, I believe.
by rjw524
Mon Jan 18, 2016 4:43 pm
Forum: Technical / Scripting
Topic: Window moves when it's in the mood???
Replies: 3
Views: 3118

Window moves when it's in the mood???

Hi, I'm trying to move a window (it's the Volume Mixer actually) that I use a "run" command to bring up. The window pops up in literally THE worst spot for the rest of the macro, so I worked for about an hour trying to figure out how to get it to move. Various combination of Handles/Window types, et...
by rjw524
Wed Jan 13, 2016 5:14 pm
Forum: Technical / Scripting
Topic: Having trouble with "Position" Command...
Replies: 5
Views: 4061

Re: Having trouble with "Position" Command...

Quick question...

Is it necessary to break the clipboard into a lined array?

Is there any way to just leave it as a block of text if that better suited one's purpose?
by rjw524
Wed Jan 13, 2016 5:12 pm
Forum: Technical / Scripting
Topic: Having trouble with "Position" Command...
Replies: 5
Views: 4061

Re: Having trouble with "Position" Command...

Just do another Position search using the position of the trigger word as your starting point: Let>str=It was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness, it was the epoch of belief, it was the epoch of incredulity, it was the season of Ligh...
by rjw524
Wed Jan 13, 2016 4:02 pm
Forum: Technical / Scripting
Topic: Having trouble with "Position" Command...
Replies: 5
Views: 4061

Having trouble with "Position" Command...

Hello, I have a macro that copies text from a dynamically generated page to the clipboard. After copying the text, I try to use the "Position" command to find a particular "trigger" word. If this word is present then that initiates a search for a second word whose position MUST be after that of the ...
by rjw524
Thu May 28, 2015 6:40 pm
Forum: Technical / Scripting
Topic: Email Monitoring Macro that Triggers another Macro to run...
Replies: 1
Views: 2292

Email Monitoring Macro that Triggers another Macro to run...

Hi All, I've been trying to write a macro that does the following: 1) Triggers a 2nd Macro when a specific email address, WITH A SPECIFIC SUBJECT LINE, gets a new message in its Inbox. I seen some examples on the forums, for this, but for some reason I've not been getting the "RetrievePOP3" command ...
by rjw524
Wed Apr 29, 2015 10:30 pm
Forum: Technical / Scripting
Topic: Simple Question about Macro Design...
Replies: 3
Views: 2933

Re: Simple Question about Macro Design...

Honestly, I don't know what I would do without you two. I feel like a part of my paycheck should be going to you guys every month.

well...almost, lol.
Sign up to our newsletter for free automation tips, tricks & discounts