koden

just saw that mouse arrow cursor changes to a hand when button is reached.

maybe that could be used ?

Only click if mouse cursor is a hand?

Like this

Mouse Move Screen 416, 382

if mouse cursor is hand point

mouse left button click

Else

Macro stop

End if

I have a website where it's not possible to use TAB

therefore I use mouse to click a button.

Sometimes the website takes time to load that area I have to click in at my macro clicks the wrong place

wait to webpage to load not working here

So I would like that mouse only click if it's on the button that has a specific color.

else macro should stop

since button is small and have diff colors (text is white and button background purple) maybe the other way around is to say macro stop if color is a wrong color.

But anyway... I can test myself... but not sure where this color function is to find?

yes off course... I must have been tired 🙂

Thanks

Hi

I have a excell sheet with a lot of cells with numbers.

My macro copy a number and uses the number on a website.

it goes back to excell and copy next number.

How do I in the excell sheet mark the just copied number ex. BOLD, so that this number is bold in excell (I can then see that this number has been "used")?

I thought it was a text command, but did not find any command matching.

hi forum

found this old thread...

how do I change the win+ abort macro option in playback?

change the filled in win+ to win+end or something else

On my old laptop I had a break button and i used that to abort a macro

but my new laptop does not have break or pause, which also is an option to use.

ahh.. yes have to go this way around.. sure

thanks

maybe I need to explain 🙂

is there a way to get the command "wait for webside to load" to read the last X sign and repeat macro if X= with a number between 1 and 9?

I have a macro where I use this.

But I have webside that's named almost the same when it changes.

ex: before i hit enter it's named for ex.   test.online.com/#=

When I hit enter it changes to  test.online.com/#=X

X is a number that changes....

can I use a "wait for webside to load" no matter what number is in X place?

Hope it's to understand..

yes that could be... tab form top to bottom.

Not sure I completly understand this with search.

But if i search the word that is typed in this box, where i use mouse to click on because tab not works.

Then the word is highlighted in the box.

But still no tab or enter that can activate box.

Another issue with web site is that in the adress field (www field) the site name is (changed a bit but quite similar).

https://sys-online.dk/sys/#a_

when click in the first box where I should paste numbers it removes https:// and is now just sys-online.dk/sys/#a_

But whatever it is I can in macro express under timing "wait for window title" only see a window called "sys-online - google chrome"

The same when I on web site goes further into website...

The name in timing is still the same  "sys-online - google chrome"

yes that could be... tab form top to bottom.

Not sure I completly understand this with search.

But if i search the word that is typed in this box, where i use mouse to click on because tab not works.

Then the word is highlighted in the box.

But still no tab or enter that can activate box.

Another issue with web site is that in the adress field (www field) the site name is (changed a bit but quite similar).

https://sys-online.dk/sys/#a_

when click in the first box where I should paste numbers it removes https:// and is now just sys-online.dk/sys/#a_

But whatever it is I can in macro express under timing "wait for window title" only see a window called "sys-online - google chrome"

The same when I on web site goes further into website...

The name in timing is still the same  "sys-online - google chrome"

yes TAB is normally fine.

This TAB makes the web site new window jump around the screen until it reach it's destination.

It works but sometimes fails and I think it's because of this jumping up and down.

I will try that.. but where did you find a way to check colors.

have looked and could not find a command that can check colors

But not sure it's much better than the TAB.

I assume it's the web site constuction that is not macro freindly.

Maybe there was a way around for that kind of sites.

yes thanks... working...

My macro hit a button on a web site which opens a window on the site.

This window is not visible in macro "activate window" and I can't do a window check.

In this new window I have to insert a date in a field.

I can reach the field by TAB 10 times.

Is there any other ways to get these windows active in another way?

Thanks.. yes off course.

Now I remeber using this 10 years ago

Is there a way to do check on what is typed in the N1

Ex. has to be numbers and at least 6 numbers and the last 2 is always 2 and 1 for this year

is there a quick short key to stop a running macro

I have created a simple macro that copies from excell and paste into webside.

I would like to have the macro to repeat a amount of times.

is it possible in some way to start the macro with a prompt where i type tat it f.ex. should run 20 times..

So when finished then start from beginning again.

And do that 20 times or more.

ok will try

thanks

Thanks...

Actually I did finish the macro yesterday with simple TAB commands.

Because we have to use it right now.

Will have a look at the ASCII file version as soon I have the time.

I got a little problem on the web site that I can't find out.

Web site seems to be in 2 parts. An upper and a lower part.

I can't get to the lower part without a mouse click.

I hate to use mouse.... but at the moment I can't get TAB or anything else to catch the point.

Could there be a solution for that which I don't know about.

I know it's difficult to say much about without info about the website.

Hi

I have used macro express before..but more than 10 years ago.

So I'm starting from almost scratch 🙂

I need to paste some text and numbers in from a excell into a web side.

Actually quite simple

In excell I have 3 columns with more than 1000 rows.

What i need is to copy column 1,2 and 3 row 1 content into 3 variables and then go to website and paste it to right places.

Empty the 3 variables after use.

Then go back to excell and again copy row 2 into the 3 variables

But I have forgot how to do this the right way

What is the best solution?

to be in excell column 1 and row 1 and ctrl+C put into variabel T1, tab ctrl+c put into var. 2 a.s.o.

I know how to jump between the windows and tab around and that kind...

Thanks...internet explorer

wait for web page need a URL.

I can't find URL's to this kind of program running in internet explorer....

No properties to look in...

can I see Url other places?

:-) have not seen this command before...thanks...

I use this command "wait for window title".

I use it a lot in a program running in internet explorer.

The problem is that sometimes the program has some respons time.

The window opens but the content ind the window is slower and opens later.

the command "wait for window title" see the window as opened and goes on to next step.

But the window is'nt fully opened.

Can I do anything about that?

In the moment i just put "delay" in the macro, but the days where the internet explorer program runs fine, it gives to much delays....

I love you guys :-)

Thanks....

I have a macro that in a mainframe window does this:

ctrl+a (all text marked)

ctrl+c (all text copied...more than 2000 characters)

open notepad

ctrl+v

All characters is now in notepad....

BUT

When i use the modify string command to remove characters after characters 999, then it will not copy text to notepad.

I use:

ctrl+a (all text marked)

ctrl+c (all text copied...more than 2000 characters)

variable set string T51 from clipboard

variable modify string copy part of T51 to T50 (Copy from position 1 to 999)

variable modify string save T50 to clipboard

open notepad

ctrl+v

Not working. I have tryed speed 3 times slower and with 1000 MS between each comand..

What am I doing wrong?

I think it's something about what i copy from the mainframe. When i make ctrl+v and C to notepad it's in notepad as characters and I can edit the characters.

maybe before it gets to notepad it's a picture or something that modify string can't handle...

Can i do something else?

at the moment i first copy to notepad and back to clipboard and then use modify...

that works, but it's an extra program and time...

line 8 to 17 in the attached macro file

test.mxe

OK. yesterday I got a counter in notes that count mails,and give me a number in a pop up box.

I can copy that number to clipboard.

Can I use this together with your loop?